| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Double Lookups
Hi
Country Product Value Germany Car 1,500.00 Germany Bike 200.00 Japan Bike 300.00 Japan Van 2,500.00 Japan Car 10,000.00 Based on the above data,i need a formula that can find "Germany" & " Bike" and provide me the value of 200.00. Please help? regards |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Double Lookups
One way:
=SUMPRODUCT((A2:A6="Germany")*(B2:B6="Bike"),C2:C6 ) Should there be more than 1 instance of Germany & Bike in the same row within the range, the expression will return the sum of values. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "AFA" wrote: Hi Country Product Value Germany Car 1,500.00 Germany Bike 200.00 Japan Bike 300.00 Japan Van 2,500.00 Japan Car 10,000.00 Based on the above data,i need a formula that can find "Germany" & " Bike" and provide me the value of 200.00. Please help? regards |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Double Lookups
Hi Max,
thanks for the answer. "Max" wrote: One way: =SUMPRODUCT((A2:A6="Germany")*(B2:B6="Bike"),C2:C6 ) Should there be more than 1 instance of Germany & Bike in the same row within the range, the expression will return the sum of values. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "AFA" wrote: Hi Country Product Value Germany Car 1,500.00 Germany Bike 200.00 Japan Bike 300.00 Japan Van 2,500.00 Japan Car 10,000.00 Based on the above data,i need a formula that can find "Germany" & " Bike" and provide me the value of 200.00. Please help? regards |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Double Lookups
welcome, AFA.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "AFA" wrote in message ... Hi Max, thanks for the answer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
| LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions | |||
| Lookups | Excel Discussion (Misc queries) | |||
| 2 way lookups | Excel Worksheet Functions | |||
| Double Lookups | Excel Worksheet Functions | |||
Linear Mode
