I have a Pivot Table with a colum like this:

549
910
50
919
980
642
937

I have another list like ColA below:

980 Y
642 Y
937 Y
234 N

I amtrying to find a formula for ColB above. The formula returns Y if the
value in ColA appears in the Pivot Table.

Thank you in advance.