Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Data in Another Table
I need to instruct MS Excel to look in the cells in column D of Table One,
see if those cells match data in column H of Table Two, and if it does to insert the descriptions from column I of Table Two in column E of Table One. In other words, I am matching codes between two spreadsheets, finding the description of the codes and placing them in a new column in the original table. 'Suggestion, please. Sincerely, DOUG ECKERT |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Data in Another Table
You don't say what row your data starts on - I'll assume row 2, so put
this in E2: =IF(ISNA(MATCH(D2,H:H,0)),"",VLOOKUP(D2,H:I,2,0)) Copy down for as many entries as you have in column D. Hope this helps. Pete On Dec 1, 10:32*pm, DOUG wrote: I need to instruct MS Excel to look in the cells in column D of Table One, see if those cells match data in column H of Table Two, and if it does to insert the descriptions from column I of Table Two in column E of Table One. * In other words, I am matching codes between two spreadsheets, finding the description of the codes and placing them in a new column in the original table. *'Suggestion, please. Sincerely, DOUG ECKERT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup only when data exists in table | Excel Discussion (Misc queries) | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Table Lookup using two data elements | Excel Worksheet Functions | |||
Lookup in data table - too many arguments? | Excel Worksheet Functions | |||
lookup? list data into summary table | Excel Worksheet Functions |