The formula seems to work for me as you've written it. Try checking the
spelling of "Inventory" between your formula and the actual SheetName.
Otherwise, the difference between O4 and it's corresponding value on the
Inventory Sheet may be that one is formatted as TEXT and the other as a
number

Vaya con Dios,
Chuck, CABGx3



"wnfisba" wrote:

I need some serious VLOOKUP Help.

I ahve the follwoing formula which is returning "True" in all cases and I
know that's not the case because I've checked the data.

Can anyone help me???

Does anyone know of any good web sites that explain how VLOOKUP works???

Here's the formula...

=IF(ISNA(VLOOKUP(O4,Inventory!$A$5:$A$1712,1,0))," True","False")

Any help would be greatly appreciated...

Thanks!