vlookup

[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

 

[Peo Sjoblom]

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?

 

[Dan]

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

(A4,DAILYSALES,3,FALSE)),0,(VLOOKUP
(A4,DAILYSALES,3,FALSE)))

 

[Peo Sjoblom]

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..

 

[Dan]

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

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)))

.