vlookup formula

G

Guest

I have some part numbers that I am searching for externally using the "False" qualifier. Some fields return a value of "#N/A" as there is no value. Can anyone help me with a formula to return a fixed value (i.e. 1.0) if the formula returns "#N/A" as a value?


THanks

Paul
 
T

T. Valko

Try something like this:

=IF(ISNA(VLOOKUP(.....)),1,VLOOKUP(.....))

--
Biff
Microsoft Excel MVP


I have some part numbers that I am searching for externally using the "False" qualifier. Some fields return a value of "#N/A" as there is no value. Can anyone help me with a formula to return a fixed value (i.e. 1.0) if the formula returns "#N/A" as a value?


THanks

Paul
 
P

Peo Sjoblom

You can use ISERROR as well however since the result of a lookup
not found always is #N/A it is better to use that because if you have some
other error it might be good to know that particular error.

--


Regards,


Peo Sjoblom
 
Top