VLOOKUP

  • Thread starter Thread starter pm
  • Start date Start date
P

pm

I'm getting an error "N/A" in the cell this formula is located in because
nothing is populated in the first column. How do I "" the error?

Thanks.

=VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE)
 
Maybe

=IF(ISERROR(VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE)),"",VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE))

Mike
 
Look in the help index for ISNA to see the is functions
Click to expand...

You could try:-

=IF(ISNA(VLOOKUP($A8,Users!A$2:CH$1982,36,FALSE)),"",VLOOKUP($A8,Users!
A$2:CH$1982,36,FALSE))

This would return a blank cell as the ISNA function returns TRUE if
the #NA error is present. If the VLOOKUP returns a value then it will
show in the cell as expected.

HTH,

Matt Richardson,
http://teachr.blogspot.com
 
Back
Top