=SUMPRODUCT(--($C$2:$C$5=F2),--($D$2:$D$5=G2),$E$2:$E$5)


F2=101
G2=6001

HTH

"Brian" wrote:

I have the following scenario:
A B C D E
1Hotel# 1Job# 2Hotel# 2Job# Staff#
101 6001 100 5002 231356
103 5002 101 6001 253586
406 2025 503 2025 365412
503 2025 601 6004 894561

The data from col A & B are connected by row ... meaning 101 & 6001 go
together and should not be worked individually (thus the number 1 in the col
headers connect those two cols, and the number 2 in the col headers connect
those two columns C and D).

I want to find a way for the formula to take the data that is in the same
row in col A/B, in this case 101/6001, and find a match anywhere in col C/D,
and return to me the data in col E that is in the same row as the match. So,
for instance, row 1, I have 101 and 6001. I look down col C/D and find a
match 101 and 6001 in the second row. So, the returned data would be 253586
because it is in the same row as the match found in C/D.

Sorry, for the long way about this. I thought I could use sumproduct.