omdkhaleel
10-29-2013, 03:26 AM
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
10-29-2013, 04:17 AM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.