Hi, I think is easier to make a reference to the data base instead of the
PTable.

does it help?
Marcelo

"carl" escreveu:

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.