To deal with #NA

[Amin]

i want to stop the #N/A showing in my cells where the VLookup has been used
is it possiblt to stop them from showing when a a lookup value is not yet
available.

 

[ozgrid.com]

see http://www.ozgrid.com/Excel/stop-na-vlookup.htm

 

[Jacob Skaria]

One wa is to use ISNA() IF() combination to handle the error

=IF(ISNA(vlookupformula),"",vlookupformula)