I have a dropdown that selects from several text "keys," like so:
List of items:
I'm trying to use these keys to run a lookup on a separate sheet, with the following formula:
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?