Help with vlookup and multiple lines

[ahooper]

I'm not that great at excel and just learning some of the basics so hopefully this doesn't get too embarassing....

I'm trying to use a vlookup to combine one spread sheet with another. The vlookup works great when it comes to the first date but I haven't figured out how to make it go to the next date.

Goes like this:

first sheet:
location1 date1 value1
location1 date2 value2
location1 date3 value3
location3 date1 value4
location3 date2 value5
location3 date3 value6
etc.

second sheet:
location1 date1 value7
location1 date2 value8
location1 date3 value9
location2 date1 value10
location2 date2 value11
location2 date3 value12
location3 date1 value13
location3 date2 value14
location3 date3 value15
etc.

I'm trying to get the first sheet to pull data from the second sheet and return the value matching the location AND the date... and not every location on the first sheet is on the second sheet and vice versa...

Please help????

Thanks.

 

[Robert Mika]

try this one:

=SUMPRODUCT(--(Sheet2!$A$1:$A$9=Sheet1!A1),--(Sheet2!$B$1:$B$9=Sheet1!B1),Sheet2!$C$1:$C$9)

 

[ahooper]

Thx for trying to help! I couldn't get that to work but I searched around and found another way around it... thanks again