Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |