VLOOKUP
 

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)

VLOOKUP
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pm" wrote in message
...
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)

VLOOKUP
 

Maybe

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

Mike

"pm" wrote:

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)

VLOOKUP
 

On Jan 25, 11:29 pm, "Don Guillett" wrote:
Look in the help index for ISNA to see the is functions

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"pm" wrote in message

...

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)

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