Find or Lookup?

[rebdye]

I am trying to look to see if a part number is in another worksheet an
if so return Yes. How do I do this? I have tried several functions bu
they all return name so I am not even sure if I am doing this correctly