Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function needed to search and pull data from 1 table to another
Really need some help to determine what function/formula to use.
Table A contains names of Learners and their job functions. The same learner could be there twice, and some learners have no job funtion. Learner Name Job Function A, EASWAR Marketing A, EASWAR Marketing Aarts, Hans Abib, Marcelo Research Abib, Marcelo Research Abo El Azayem, Mohamed HR Abou-Taleb, Khaled Marketing Aceña Garcia, Luis Sales The second table just has learner names. I need to pull the job function from the other table to this. However, note that there could be someone on this list that is not in the list above, or again, in here twice. Learner Name A, EASWAR A, EASWAR Art Jones Abib, Marcelo Abib, Marcelo Abo El Azayem, Mohamed Abou-Taleb, Khaled Cat Smith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the best way to pull in external data from SQL table | Excel Discussion (Misc queries) | |||
Macro needed to pull data from one worksheet and enter it in anoth | Excel Discussion (Misc queries) | |||
Search function needed (sumproduct?) | Excel Worksheet Functions | |||
Pull Pivot Table Data | Excel Discussion (Misc queries) | |||
Pull pivot table data | Excel Discussion (Misc queries) |