| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find text from 1 col in 2nd col & return value from 3rd col
Hello,
I have: Sheet1 with empoyee numbers on A:A and last names on C:C Sheet2 with concantinated names (lastname,firstname) on B:B (always with a comma between if that helps). I need some kind of lookup/search formula on sheet2 A:A to extract the last name from sheet2 B:B, then take this extracted last name and match it up on sheet1 C:C , then return the emplyee # of sheet1 AA from the same row. Thanks in advance for any help, Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value between range & return text | Excel Worksheet Functions | |||
| FIND function does not return ZERO when text is not found | Excel Worksheet Functions | |||
| Find text and return - NOOB question | Excel Discussion (Misc queries) | |||
| Find $ in a string of text and return numbers | Excel Discussion (Misc queries) | |||
| Look for similar text and find the largest value and return value | Excel Discussion (Misc queries) | |||
Threaded Mode
