Sean15
Wellknown Member
 Joined
 Jun 25, 2005
 Messages
 609
 Office Version

 2019
 Platform

 Windows
Hi:
The formulas in range J26:L28 are not returning the required results. Could you help please?
The formulas in range J26:L28 are not returning the required results. Could you help please?
INDEX & MATCH with multiple criteria.xlsx  

E  F  G  H  I  J  K  L  
21  derek  exec  1250  
22  mark  payroll  1425  
23  paul  IT  5300  
24  
25  IT  exec  payroll  
26  derek  #REF!  1250  #REF!  
27  mark  #REF!  1425  #REF!  
28  paul  #REF!  5300  #REF!  
29  
Sheet1 
Cell Formulas  

Range  Formula  
J26:L28  J26  =INDEX($G$21:$G$23,MATCH($I26,$E$21:$E$23,0), MATCH(J$25,$F$21:$F$23,0)) 