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, 8 views)

Hi
in I2 enter =INDEX($B$2:$D$4,MATCH($G2,$A$2:$A$4,0),MATCH($H2, $B$1:$D$1,0)) and drag down

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Much appreciated!! it worked!