Oddly, when I added "FALSE" at the end of the formula for the range lookup,
it worked. Kind of strange that asking for an exact match works but
approximate does not.

"Woody13" wrote:

Can you use VLOOKUP where you try to match text as the lookup value? When I
use the VLOOKUP function I get no return. No error message. Nothing. Not
sure what it is and I'm wondering if text is the problem.