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.

many thanks!

Debbie