vlookup formula

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
Back
Top