VLOOKUP Returning Wrong ValueDec 14, 2006
I have this formula that returns a grade mark for a specific score in a test:
using these values in the lookup table:
The problem comes where the Grade is A or A* as the Vlookup table can't differentiate the two. Anyone know how to modify the formula so that A and A* are seen as distinct values?