Using a VLookup within an IF statement

So here's what I am trying to do:

I have two tabs of data.

Lets say the first tab has four columns:

A, B, C, D -

The second tab also has four Columns:

A, B, C, D - Column D is a calculation

I want to have Column D on the first tab result "Cleared" if the company listed in Column B has a zero balance in Column D of the second tab. Otherwise leave blank.

Here is the formula I tried, but I always get a blank instead of a cleared:

=IF(VLOOKUP(B1,'AP Testing'!$A$2:$D$118,4,FALSE)="0","Cleared","")

Any thoughts?

Originally Posted by Tony Valko

Try removing the quotes from around the 0.

When you quote numbers Excel evaluates them as TEXT.

"0" and 0 are not the same!

And you are correct and I am an idiot. That fixed the formula! Thank You