How do I only get valid "answers" in a VLOOKUP function (no #N/A's
I use a lot of VLOOKUP functions in formulas and am frustrated by the #N/A
results whenever the value I'm looking for isn't in the reference list range.
Is there a simple way to have a formula leave the result blank if the value
isn't found?
|