vlook
Try this...
=if(isna($J33), "Error Message", VLOOKUP($J33,'2006 Discount
Grid'!$A$1:$O$386,12,FALSE))
--
HTH...
Jim Thomlinson
"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
|