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?