That shouldn't matter, excel will read the value result of the vlookup, not
the formula itself.

You have another issue producing the #N/A

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"Wanna Learn" wrote in message
...
Thanks "Teethless mama" I copied the formula exactly as it is below and
it
does not work. Let me rephase. the value in cell J33 is also a lookup
formula

"Teethless mama" wrote:

=IF(ISNA(VLOOKUP($J33,'2006 Discount
Grid'!$A$1:$O$386,12,FALSE),"",=VLOOKUP($J33,'2006 Discount
Grid'!$A$1:$O$386,12,FALSE))

The above formula will trap the #N/A


"Wanna Learn" wrote:

Hello I have a formula in a cell and the response is #NA. Here is
the
formula
=VLOOKUP($J33,'2006 Discount Grid'!$A$1:$O$386,12,FALSE) the reason
I'm
getting the #NA response is that $J33 is also a Vlookup. but I don't
know
how to correct this. Can one of you geniuses help please and thanks