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

index / match
 

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

On Feb 9, 3:05*pm, Deborah wrote:
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

index / match
 

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
--
Regards
Roger Govier

"Deborah" wrote in message
...
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