vlook
=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
|