Prev: How to find the custom xml tags in a workbook
Next: Establishing a Time Window
From: Amin on 28 Apr 2010 01:46
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.
From: ozgrid.com on 28 Apr 2010 01:59
see http://www.ozgrid.com/Excel/stop-na-vlookup.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Amin" <Amin(a)discussions.microsoft.com> wrote in message
news:37FE3F4E-D7CD-43F1-9B96-19A49E643FAA(a)microsoft.com...
>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.

From: Jacob Skaria on 28 Apr 2010 02:06
One wa is to use ISNA() IF() combination to handle the error

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

--
Jacob (MVP - Excel)


"Amin" wrote:

> 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.
 | 
Pages: 1
Prev: How to find the custom xml tags in a workbook
Next: Establishing a Time Window