find text from 1 col in 2nd col & return value from 3rd col
Robert wrote:
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
In Sheet2!A2 and fill down:
=INDEX(Sheet1!A:A,MATCH(LEFT(B2,FIND(",",B2)-1),Sheet1!C:C,0))
This will not work properly if any duplicate last names exist.
|