SUMPRODUCT would do it.
--
David Biddulph

"Jas" wrote in message
...
Hi,

I am trying to match 3 data points and return the value for the cell they
intersect at - without using concatenate if possible.

In the below table I would like to return the value for Product A, Country
UK, Week 2 i.e. 20 - any ideas?

Product Country Week Qty
A UK 1 10
A UK 2 20
A UK 3 15
A FR 1 10
A FR 2 12