Match two columns, return a third piece of data
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!
|