Explanation
Note: a simpler approach would be to alter the table used by VLOOKUP directly.
But this example explains the mechanics of testing and overriding output from VLOOKUP.
This formula is based on a simple grading exampleexplained in detail here.
Note match mode is set to approximate.
Otherwise, return the result from VLOOKUP.
The result of “x” can be customized as desired.
To display nothing, provide anempty string("").
Instead, it tests the incoming score value and bypasses VLOOKUP entirely if below 60.
