View Single Post
  #1   Report Post  
SWEdwards
 
Posts: n/a
Default 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?