index / match

  • Thread starter Thread starter Deborah
  • Start date Start date
D

Deborah

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
 
What do you expect to see in your second table? Are you wanting to add
the values from the first table which match the second table criteria?

Pete
 
Hi Deborah

Enter in B2 of Sheet2
=INDEX(Sheet1!$A$:$C,MATCH(Sheet1!$A:$A,$A2,COLUMN(B1),0)
Copy Across and down as required
 
Back
Top