Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlook
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlook
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlook
Following the discussion until now, I have a couple of questions.
1. If I understand you correctly, you have pinpointed your problem down to the formula returning #N/A because J33 itself is #N/A, J33 being the result of a lookup which failed. Is this correct? 2. What do you mean by "correct"? Avoid the error value and return blank or a message of choice? If J33 required a value to be found and the value was not found it is reasonable that a query based on J33 will return "not found" in any form. If you want to trap the error of J33 then you could use IF(ISNA(J33),a,b). But what could these values a, b be? Whatever they are, either they will not be in your lookup table ('2006 Discount Grid'!$A$1:$O$386) or they could default to a certain value (unlikely). So I suggest you specify more clearly what it is you want to avoid. HTH Kostis Vezerides Wanna Learn wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlook
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlook
Thank you everyone . I could not have done it without you. J 33 was a
result of a lookup -and that table was formated as text - and the discount grid table was formatted as number doh! again thanks everyone "Jim Thomlinson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use vlook to show the value of a cell using a formula | Excel Discussion (Misc queries) | |||
How to use Vlook up | Excel Discussion (Misc queries) | |||
Subject: vlook up 1/25/2006 1:39 PM PST | Excel Discussion (Misc queries) | |||
vlook up | Excel Discussion (Misc queries) | |||
How do I use drop down list selections/values in a vlook up formu. | Excel Discussion (Misc queries) |