Forum Discussion
IF Function
I'm trying to assign a number value to a previously assigned rank. For instance, ranking #1 receives a value of 30, ranking #2 receives a value of 27, ranking #3 receives a value of 24, etc. I can'...
Assuming for the moment you have these values assigned somewhere, say 'Rank' in column A with values starting in A2 (1, 2, 3, etc.), and 'Value' in column B with values starting in B2 (30, 27, 24, etc.), going down to row 11 (can be however long you want), you could use the following type of formula:
=LOOKUP(E1,A2:A11,B2:B11)
My assumption here was the value to be looking up was in cell E1.
=LOOKUP(E1,A2:A11,B2:B11)
My assumption here was the value to be looking up was in cell E1.