I have a named range called A2Bounds25:
| Grade | Percentage |
|---|---|
| A* | 80 |
| A | 71 |
| B | 60 |
| C | 49 |
| D | 38 |
| E | 27 |
I pull the percentage from A2Bounds25:
=VLOOKUP(F74, (INDIRECT($K$3)),2)
where F74 contains the grade I want to look up, and K3 the string A2Bounds25. This works for all grades except A.
Even if I change A to any other unused letter (and update A2Bounds25 accordingly) it still refuses to pull the percentage for an A. All other grades pull the correct percentage, and I have used the same formula in each cell other than changing F74 to F75 and so on. If I replace the cell reference with "A" it still will not work.
How can I correct this?
Set the range lookup option to FALSE:
=VLOOKUP(F74, (INDIRECT($K$3)),2,FALSE)