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