vlookup

  • Thread starter Thread starter Dan Schoonmaker
  • Start date Start date
D

Dan Schoonmaker

I'm getting a #VALUE! error when using a vlookup formula.
The value I am looking for is not in the named range list
& I am using the IF(ISNA w/ the statement which should
return a value of 0. The formats are all General. Any
ideas?

Thanks,
Dan
 
If you get a value error you must have a value error in the table or else
you must do some calculation with text values.. I guess you thought it was
of no importance to
post the formula?
 
-----Original Message-----
If you get a value error you must have a value error in the table or else
you must do some calculation with text values.. I guess you thought it was
of no importance to
post the formula?
--

Regards,

Peo Sjoblom





.
Here is the formula: =IF(ISNA(VLOOKUP
Click to expand...
(A4,DAILYSALES,3,FALSE)),0,(VLOOKUP
(A4,DAILYSALES,3,FALSE)))
 
If I create a range called DAILYSALES, use your formula everything works
fine
unless I have an error within the lookup. I can only assume there is a link
somewhere
to the error, your formula itself should not return an error.
Only other option is that if you under tools>options>transition have checked
[Transition formula evaluation], if you do uncheck it..
 
The Transition formula evaluation option fixed it.

Many Thanks,
Dan
-----Original Message-----
If I create a range called DAILYSALES, use your formula everything works
fine
unless I have an error within the lookup. I can only assume there is a link
somewhere
to the error, your formula itself should not return an error.
Only other option is that if you under
Click to expand...
tools>options>transition have checked
[Transition formula evaluation], if you do uncheck it..
--

Regards,

Peo Sjoblom


wrote
in message
(A4,DAILYSALES,3,FALSE)),0,(VLOOKUP
(A4,DAILYSALES,3,FALSE)))
Click to expand...


.
Click to expand...
 
Back
Top