I'm a beginner user of lookup, I have two sheets the first one ( Data) contains names, the second Sheet ( Source) contain names & their codes, what i need to do is to use vlookup formula to transfer names in sheet one to code in source sheet2, If i use the following formula
=VLOOKUP(LEFT(A2,SEARCH(" ",A2)-1),Source!A$2:B$45,2)&" "&VLOOKUP(REPLACE(Data!A2,1,SEARCH(" ",Data!A2),""),Source!A$2:B$45,2)
on the sample file , the result will be ( R5 S2), that is the first & second Name in A2 Cell in data sheet, I need the result to be ( R5 S2 R6 M2). thanksI'm attaching a file for more clarification.
Sample.xlsSample.xls
Bookmarks