Forum Discussion
v lookup doubt
Q. The Iist has employee names and badge#s of XYZ Inc.Their Manager name in found in the other table, you will need to use the employee badge to lookup their manager in the manager table. Note Manage...
=INDEX($B$3:$F$10,MATCH(B19,$A$3:$A$10,0),MATCH($B$15,$B$2:$F$2,0))
Maybe with Index and Match as shown in the attached file.
thank you