=IF(ISERROR(VLOOKUP([your vlookup])),"n","y")

Dave
--
Brevity is the soul of wit.


"Katie" wrote:

I need a formula that will lok up what is in a cell an another worksheet, and
return "y" if it finds it and "n" if it doesn't

I've tried using an if ststement with a v look up but I can't seem to get it
right