Hello,
I have search multiple forums and sites but can't seem to quite get what I am looking for (story of my life...).
I have one file, with two sheets. I need to compare column "B" (sheet 1) with with column "A" (sheet 2). For every matching result, I then need the corresponding data from column "B" (sheet 2) to be copied to column "C" (sheet 1).
I have tried VLOOKUP as well as playing with =IF(ISNA(MATCH... statements, but I can't figure out what I am missing.
Any help is greatly appreciated!!!
Bookmarks