To deal with #NA

A

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.
 
J

Jacob Skaria

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

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