Thread: Does X appear in Y? List

Hi, I have a very simple problem.

Basically i want a formula where it says if a value appears in another list on a different tab

IE:

I have 2 tabs both with part number lists on. Rather than check manually if a part appears on both i want it to check for me

EG

IF A1 (contains) 12345 Say "Y", If not say "N"

I dont think an IF is the right thing here.

I also need to copy and past the two lists each week so the formula will have to be generif to whatever code appears in that week, IE< A1 could be 12345 in week 1, but 98765 in week 2.