On Mar 6, 11:55*am, DebbieV wrote:
Hi

I have the following data
* * * * A * * * B * * * * C * * * *D * *E
1 * * * 1/2/08 * * * Pen * * * * * $2.00 * * * *MK * * *Stationery
2 * * * 3/6/08 *coffee *$5.00 * FD * * *Supplies
3 * * * 3/4/08 *taxi * *$5.90 * FF * * *transport
4 * * * 5/7/08 * * * tea * * * * * *$6.90 * * * FD * * * * * *Supplies
I want to be able to look up E col and where the value 'supplies' has
been selected from the drop down menu return the date that appears in
column A.

Plus - I then want to return the dollar amount that corresponds to the
date & 'supplies'.

many thanks!

Debbie