G
Guest
I have two tables of data. Each contains the column "item number". All of
the item numbers exist in table one, but only some exist in table two. I
would like to return the matching price from table 2 into a second column in
table 1 (and leave all other non-matching items blank).
I have been scanning the discussion groups and haven't found exactly what I
need yet. I've playing around with IF, VLOOKUP, MATCH, COUNT and INDEX, and
I'm close but not there yet.
Any ideas?
Thanks!
the item numbers exist in table one, but only some exist in table two. I
would like to return the matching price from table 2 into a second column in
table 1 (and leave all other non-matching items blank).
I have been scanning the discussion groups and haven't found exactly what I
need yet. I've playing around with IF, VLOOKUP, MATCH, COUNT and INDEX, and
I'm close but not there yet.
Any ideas?
Thanks!