No it wasn't that, I finally managed to work it out it's:
=IF(ISNA(VLOOKUP(F14,IntWE4Oct,2,FALSE)),0,VLOOKUP (F14,IntWE4Oct,2,"FALSE"))

--
Sara


"Barb Reinhardt" wrote:

I just noticed. Take the " out after FALSE and try it again.
--
HTH,
Barb Reinhardt



"Sara" wrote:

Syetem just tells me that it doesn't like the formula - no reason given
--
Sara


"Barb Reinhardt" wrote:

They look good to me. What doesn't work?
--
HTH,
Barb Reinhardt



"Sara" wrote:

I have Excel 2000 & have followed previous thread suggestions of:

=IF(ISNA(VLOOKUP(F14,IntWE4Oct,2,FALSE),0,VLOOKUP( F14,IntWE4Oct,2,FALSE"))

and

=IF(ISNA(VLOOKUP(F14,IntWE4Oct,2,FALSE)"",VLOOKUP( F14,IntWE4Oct,2,FALSE"))

and neither work for me - HELP!

--
Sara