=INDEX(C2:C7,MATCH(D1&E1,A2:A7&B2:B7,0))

ctrl+shift+enter (not just enter)


"Anna" wrote:

I have data as follows:
column column column C
A b(date) c(result)
1 2006/5/1 c
1 2006/5/2 c
1 2006/5/3 a
2 2006/5/1 b
2 2006/5/2 a
2 2006/5/3 c
What formula should I input that would come out result with 'b' in cell f1
when I type in d1=2, e1=2006/5/1?

Thank you for your help.