The reason the formula doesn't work is because the lack of FALSE the values of 'Grade' column are not sorted. A comes before A* when it comes to sorting the values in an ascending order, so when the VLOOKUP is lookup up the value with the exact match (FALSE) argument is missing, it will not be able to 'find' the value A, since its already overtaken by A*