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,[TABLE="width: 655"]
<tbody>[TR]
[TD="colspan: 5"]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.

[TABLE="width: 1217"]
<tbody>[TR]
[TD="colspan: 5"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Resource Name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Employee Name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]Employee Name[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Abdul Rahim[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Grover, Aditi[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Abhinav Singhal[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Verma, Abhishek[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Abhishek Darbari[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]Rahim, Abdul[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Abhishek Prasad[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]Singhal, Abhinav[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Abhishek Verma[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Darbari, Abhishek[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Aditi Chakraborty[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]A V, Rashid[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Aditi Grover[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]Baby, Binu[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Ajay Ashish[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]T, Pavan[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl66, width: 181"]Akheel Ahmed[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]T, Prem[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]Rashid A V[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][TABLE="width: 186"]
<tbody>[TR]
[TD="class: xl66, width: 186"]A, Rajeevan[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]

 

[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