Is this formula looking all over sheet.

[ghrek]

Hi

I have this formula in a workbook and asking if its looking all the way down as im getting OK from some stuff that is not in the tab called Watford

=IFNA(IF(E466=VLOOKUP(A466,WATFORD!A:E,5,),"OK","N/A"),"N/A")

Thanks

 

[Alex Blakenburg]

Try adding False (or 0) as the last parameter in your lookup.

=IFNA(IF(E466=VLOOKUP(A466,WATFORD!A:E,5, FALSE),"OK","N/A"),"N/A")

 

[ghrek]

Many Thanks