lookup and match questions

[Guest]

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.

 

[Bob Phillips]

=INDEX(C2:C20,MATCH(1,(A2:A20=D1)*(B2:B20=E1),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

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

ctrl+shift+enter (not just enter)