How to use an if then with pivot table

Hi,

This relates to a previous query but I though I would send a new query to make my request clearer.

I am trying to change a pivot table to show either "Sainsbury" or "(blank)" depending on the outcome of a search in a particular range.
I have some of the code but not enough to make it work. Here is where I am so far

IF my search finds "Sainbury" in a range D1:D100 (what is the code for this?)
THEN (is this right?)
ActiveSheet.PivotTables("PivotTable3").PivotFields("Name"). _
CurrentPage = "Sainsbury"
ELSE (is this right?)
ActiveSheet.PivotTables("PivotTable3").PivotFields("Name"). _
CurrentPage = "(blank)"

What is the complete code required to make this work? If the above is not clear enough then please let me know if it is easier to call to explain.

Thanks
Tony