Thread
:
Lookup
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Lookup
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
Replace @mailinator.com with @tiscali.co.uk
"AFA" wrote in message
...
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?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann