Matching data in multiple columns

[BuddyB]

Hopefully the experts can help on this one...

In one worksheet("payout") in have riders names (Column B) and horse names
(Column C).
In another worksheet ("teams") I have riders names (Col B) and horse
names(Col C) and in Col D I have times
In yet another worksheet (team payout) I have riders name(Col B) horse
name(col C0 and times in Col D.

The problem I'm having is this: Let's say Bill ( a rider) is riding 2
horses (Wells and Fargo). Anything I've used to compare the values in Cols B
and C will only capture the first occurance of Bill and place the same time
on both horses.

What I need it to do is match the value in Col B AND Col C then copy the
correct time and paste it into the cell next to the rider and horse (Col D)

Thanks in advance

 

[Ragdyer]

I'm confused on exactly which sheet you want the formula entered, and, ...
from which sheet you want to search for the data.

So, try this:

Sheet1
Column B = Rider
Column C = Horse
Column D = Time

Sheet2
Column B = Rider
Column C = Horse
Column D = enter this formula in D2

=SUMPRODUCT((Sheet1!$B$2:$B$20=B2)*(Sheet1!$C$2:$C$20=C2)*Sheet1!$D$2:$D$20)

Drag down to copy.