index / match

[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

 

[Pete_UK]

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

 

[Roger Govier]

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