I have a dropdown that selects from several text "keys," like so:
List of items: Pathetic,Untrained,Novice,Adept,Master,Amazing
I'm trying to use these keys to run a lookup on a separate sheet, with the following formula:
=LOOKUP(R3,Calculations!B2:C7)
Where R3 is the cell with the dropdown, Calculations is the sheet in question, and from B2 to C7 the cells are like this:
| Pathetic | 1 |
| Untrained | 2 |
| Novice | 3 |
| Adept | 4 |
| Expert | 5 |
| Master | 6 |
However, I only seem to be able to get it to return the number 6, the final value in the attempted lookup table. Am I missing an argument?
VLOOKUP
accepts a third and fourth argument as well. Try setting that to2
and0
.=VLOOKUP(R3,Calculations!B2:C7,2,0)
, but same result.R3 = 'Master'
then this would be the correct answer....