| 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 |
| 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 | |||
Threaded Mode
