Jan 23 2022 07:52 AM
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 Managers rotate randomly each month, so your lookup needs to consider the month also.
Manager Table by Month | |||||
Emp Badge# | Jan | Feb | Mar | Apr | May |
98362 | Londo, Mollari | Puri, Om | Temp Mgr1 | Prakash, Surya | Wayne, John |
12235 | Londo, Mollari | Londo, Mollari | Londo, Mollari | Prakash, Surya | Puri, Om |
78312 | Londo, Mollari | Puri, Om | Londo, Mollari | Jain, Anita | Wayne, John |
98722 | Londo, Mollari | Londo, Mollari | Temp Mgr1 | Jain, Anita | Wayne, John |
87423 | Puri, Om | Puri, Om | Temp Mgr1 | Jain, Anita | Puri, Om |
56431 | Puri, Om | Londo, Mollari | Temp Mgr1 | Prakash, Surya | Puri, Om |
23972 | Puri, Om | Londo, Mollari | Londo, Mollari | Prakash, Surya | Wayne, John |
18739 | Puri, Om | Puri, Om | Londo, Mollari | Jain, Anita | Puri, Om |
month | Feb | |
Employee Table | ||
Name | Badge# | Manager |
Prashanth, Gopi | 87423 | ? |
Tank, Ashwini | 78312 | ? |
Suri, Aviral | 98722 | ? |
Kumar, Ram | 12235 | ? |
Tendulkar, Sachin | 23972 | ? |
Maradonna, Diego | 56431 | ? |
Singh, Robin | 98362 | ? |
Kumar, Deepak | 18739 | ? |
|
Jan 23 2022 08:04 AM
=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.