VLOOKUP using FALSE & IF = 0 returning incorrect value

[AlexaS]

Ok, the problem I am having is that I have two accounts that need to be included in case they are ever used, but are not in my data list at the moment. Here is the formula I used:

=IF(VLOOKUP(V12,TB!$A$1:$E$86,4)=0, "",(VLOOKUP(V12,TB!$A$1:$E$86,4)))

V12 is the value I am looking up (in this case it is 600106). It is returning the value for 600104. I understand the concept of a fuzzy match, but when I put in 0 or FALSE, in one or both parts of the formula, it returns #N/A.

Also - the line directly below it (620305) has the exact same formula and correctly returns a "" value. There is an account in the dataset that is 620300, so I don't know why it would mess up on the first one and not the second.

Thanks for any suggestions to get this working!

-Alex

 

[Momentman]

What does this statement mean vlookup(........)=0, is it to mean if the value is not found, if thats what you mean, then you should be using something like iferror(vlookup(...))=true,.....

 

[seeker123]

you didn't tell it to find exact match try this see if it works.
=IF(VLOOKUP(V12,TB!$A$1:$E$86,4,0)=0, "",(VLOOKUP(V12,TB!$A$1:$E$86,4,0)))

 

[AlexaS]

What does this statement mean vlookup(........)=0, is it to mean if the value is not found, if thats what you mean, then you should be using something like iferror(vlookup(...))=true,.....

This worked perfectly, thank you!