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