Return a value from a row where two conditions are met

How big is the data set?

A) If it's small, you can do this with a formula. Let's assume:

1) Codes in col A
2) Dates in col B
3) Code to find in G1
4) Date to match in G2

In G3, put this formula:

=INDEX($C$1:$C$100, MATCH($G1&"-"&$G2, INDEX($A$1:$A$100&"-"$$B$1:$B$100, 0), 0))


B) If the data is large, then I would add a helper column to the data set to keep the formula robust.

1) In D2 add this starting formula:

=$A2 & "-" & $B2

2) Copy that formula down the whole dataset

3) Then use this replacement formula in G3

=INDEX($C:$C, MATCH($G1&"-"&$G2, $D:$D, 0))



These formulas will give you the column C result when the code/date matches, and #N/A (not applicable) result when no match is found.