Match two columns, return a third piece of data

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
Let's say you want to match A1 with data from Sheet2!A2:B20

=vlookup(A1,Sheet2!$A$2:$B$20,2,false)

You'll get #N/A if there is no match. To test for that, use

ISNA(cellid)
 
Back
Top