yes that worked, thank you
the second column has data, but only in some of the rows
all rows have a record found and they all have Record {3} in cell details
the lookup cell shows an array that i expand, which only shows those 3 values i mentioned, not the 2nd column in the lookup table. It does show up in the dropdown for "Target Column" in the lookup function
