Performing a Vlookup in the data sheets having emp. names in reverse order seperated by comma using Vlookup, Mid and find function only

[ektab2]

Hi everyone,

Can anybody tell me how to Map employee name from column C (in column B) matching exactly the "Resource name" given in column A Using only Vlookup, Mid and find functions. <tbody> </tbody> Resource Name <tbody> </tbody> Employee Name <tbody> </tbody> Employee Name <tbody> </tbody> Abdul Rahim <tbody> </tbody> Grover, Aditi Abhinav Singhal <tbody> </tbody> Verma, Abhishek Abhishek Darbari <tbody> </tbody> Rahim, Abdul <tbody> </tbody> Abhishek Prasad <tbody> </tbody> Singhal, Abhinav <tbody> </tbody> Abhishek Verma <tbody> </tbody> Darbari, Abhishek Aditi Chakraborty <tbody> </tbody> A V, Rashid <tbody> </tbody> Aditi Grover <tbody> </tbody> Baby, Binu <tbody> </tbody> Ajay Ashish <tbody> </tbody> T, Pavan <tbody> </tbody> Akheel Ahmed <tbody> </tbody> T, Prem <tbody> </tbody> Rashid A V <tbody> </tbody> A, Rajeevan <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[Johnny Thunder]

Use the formula below;

=VLOOKUP(TRIM(MID(C2,FIND(" ",C2,1)+1,LEN(C2))&" "&LEFT(SUBSTITUTE(C2,",",""),FIND(", ",C2))),$A$2:$A$10,1,0)

Assuming your data starts from row 2. Update accordingly