Find Text within a pivot table

[Rickerjd]

I have a very long pivot table that changes monthly due to a refresh from an external data source. The table is grabbing total dollar amounts from several locations. I am trying to write a formula on a seperate tab that states, if there is "Seattle" in the pivot table (anywhere), then the formula would state, YES. Is this possible?

 

[scottsen]

i'm sure it's possible (probably the MATCH function), but this forum is for Power Pivot question -- please try one of the other forums.