VLOOKUP

[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)

 

[Don Guillett]

Look in the help index for ISNA to see the is functions

 

[Mike H]

Maybe

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

Mike

 

[Matt Richardson]

Look in the help index for ISNA to see the is functions

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