from sumproduct to a lookup please

[Steved]

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.

 

[Steved]

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

Thankyou.