ExcelBanter - Cells shows #NA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cells shows #NA (https://www.excelbanter.com/excel-discussion-misc-queries/123675-cells-shows-na.html)

tankerman

Cells shows #NA

My VLOOKUP works fine how do I keep the cells from showing #NA when not in use.

Nick Hodge

Cells shows #NA

Tankerman

Wrap it in an IF(ISNA... combination

=IF(ISNA(YourVlookup),"",YourVlookup)

or if it's only to avoid blanks then just an if

=IF(YouLookupCell="","",YourVLookip)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk

"tankerman" wrote in message
...
My VLOOKUP works fine how do I keep the cells from showing #NA when not in
use.

All times are GMT +1. The time now is 06:23 AM.