Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) "uncreative" wrote: 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! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the speedy response, Barb, that worked for me.
"Barb Reinhardt" wrote: 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) "uncreative" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match data in 2 columns and return data from 3rd column | Excel Worksheet Functions | |||
LOOKUP two data sets for match - return 1 or 0 - Please help! | Excel Worksheet Functions | |||
Extracting single piece of data | Excel Discussion (Misc queries) | |||
Extracting single piece of data | Excel Discussion (Misc queries) | |||
Extracting single piece of data | Excel Discussion (Misc queries) |