Hi DebbieV
From what I can see you would need VLOOKUP but not sure if I understand.
Check this site, you will see information on VLOOKUP and other info (Very
good Site with Sample files )
Regards
Cimjet
http://www.contextures.com/xlOrderForm01.html
"DebbieV" wrote in message
...
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