Please ignore as I've now re done the question.

Thankyou.

-----Original Message-----
Steved

Hello from Steved

Below will do a sum off 1-City how do I change it to do a
lookup please.

SUMPRODUCT(--(Data!$A$2:$B$2001="1-City"))

Thankyou.
.