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.

Hi, try.....

=IF(COUNTIF(range,value)0,"Yes","")

Swap 'range' for the workbook/sheet/cell range (easiest to do by selecting it with the mouse rather than typing it.

Swap value for the part number or the relevant cell reference if the part number is stored.

Hopefully that will do the trick.
Let me know if not.