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