Hi everyone,

This one might be a head scratcher for you gurus out there:

Column A has a list of cells with identical values:

XX
XX
XX
XX

Column B haa cells with unique values

YX
XY
AB
RR

Column B cells are in the same row as column A cells

XX YX
XX XY
XX AB
XX RR

I am unable able to add an identifer to any of the individual cells in column A. Is there anyway I can use vlookup or a simlar took to bring up all values in column been (showing up in their own decending cells) but searching for the common value in column A? Any thoughts?