I have a reference table as per the below (xls attached:

Level A B C
3 100 200 300


4 150 170 300
5 120 130 140

A,B,C represents outcomes depending on the level.

in another sheet, I need the outcomes based on the level and rating:

Ex: if level is 4, with a rating of B, then outcome is 170..

Level Rating Outcome
3 A 100
4 B 170
5 B 130

can't figure out how to use index in this situation.

Much appreciated!!

Attached Files

Excel example for index.xlsx (10.2 KB, 10 views)