R Rami9 Member Dec 28, 2022 #1 hi all I created a table of Workers Monthly Wages in sheet (Ladder) based on their Grades and Levels And I have two dropdown list (Grades & Levels) in another sheet (Brief) I want to have current wage in cell C3 Thanks Attachments Wages.xlsx Wages.xlsx 13.3 KB · Views: 4
hi all I created a table of Workers Monthly Wages in sheet (Ladder) based on their Grades and Levels And I have two dropdown list (Grades & Levels) in another sheet (Brief) I want to have current wage in cell C3 Thanks
ETAF Active Member Dec 28, 2022 #2 =IFERROR(INDEX(table,MATCH(Brief!A2,Grade,0),MATCH(Brief!B2,Level,0)),"not in table") Attachments Wages-ETAF.xlsx Wages-ETAF.xlsx 13.8 KB · Views: 5