Value of Cell to be displayed

[omdkhaleel]

I have enclosed a sheet. Based on Grade selection against student the score value to be displayed from the above cell. Could someone help me?

[mancubus]

one way is vlookup function.
another way is index+match functions

in E6:

=VLOOKUP(D6,$D$1:$E$3,2,0)
or

=INDEX($D$1:$E$3,MATCH(D6,$D$1:$D$3,0),2)
copy down.


you can find other solutions as well.