Thread: Double Lookups
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AFA AFA is offline
external usenet poster
 
Posts: 16
Default 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