Thread: index / match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Deborah Deborah is offline
external usenet poster
 
Posts: 35
Default index / match

I have the following data

date MEETING 1 MEETING 2
01-09-2008 1 10
01-10-2008 2 20
01-11-2008 3 30

I would like a formula that gives me the value that meets both criteria:
meeting 1 on 01-09-2008.

date MEETING 1 MEETING 2
01-09-2008 ?? ??
01-11-2008 ?? ??

Thank you,

Deborah