Quote:
Test each clause of the IF statement separately to see where you error lies. If the error is in the VLOOKUP, you will need to test for or hide the error.
|
Yep, good advice. All my vlookups worked with values, but I finally figured out why it was failing. Appreciate your response.