| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
