View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna Anna is offline
external usenet poster
 
Posts: 132
Default lookup and match questions

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.