Lookup

[Guest]

Hi,

Country Month Value
Germany 1 100.00
Germany 5 250.00
UK 7 400.00
Spain 2 300.00
UK 5 250.00
Germany 9 710.00


I need to pull out the value that match to Country=Germany and Month=9.
I am sure Vlookup or offset are not possible.
What formula should I write?

 

[Sandy Mann]

Country in Column A, Month in Column B & Value in Column C:

=SUMPRODUCT((A2:A7="Germany")*(B2:B7=9)*C2:C7)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

Hi Sandy

Thank a lots. its work! you save a lot of my time scrolling down a hundred
of line and updating items manually.

 

[Sandy Mann]

Your are very welcome, I'm glad you found it useful

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk