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.