Formula Vlookup Skills

[Amitg9595]

Hello Frnds,

Here I have a list of multiple common name and using vlookup I wish to get the details of particular employee name of particular position,

Kindly get the sheet and get it resolved.



Regards,
Amit Sharma
8802811976

[devendra_dev20]

Hello Frnds,

Here I have a list of multiple common name and using vlookup I wish to get the details of particular employee name of particular position,

Kindly get the sheet and get it resolved.



Regards,
Amit Sharma
8802811976

Hi,

Please see the attached sheet...

Thanks

---

Hello Frnds,

Here I have a list of multiple common name and using vlookup I wish to get the details of particular employee name of particular position,

Kindly get the sheet and get it resolved.



Regards,
Amit Sharma
8802811976

Also use this one

[devendra_dev20]

Hello Frnds,

Here I have a list of multiple common name and using vlookup I wish to get the details of particular employee name of particular position,

Kindly get the sheet and get it resolved.



Regards,
Amit Sharma
8802811976

Hi,

Please use this function through vlookup function.
also attached sheet.

VLOOKUP($A5&MATCH($A5,QUERY!$A$2:$A$19,0)-1+$B5,CHOOSE({1,2,3,4},QUERY!$A$2:$A$19&ROW($A$1:$A$18),QUERY!$B$2:$B$19,QUERY!$C$2:$C$19,QUERY!$D$2:$D$19),2,0)

Thanks
Devendra Adhikari
8743022202