| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching & Returning values
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching and returning values to a master sheet in Excel 2007 | Excel Worksheet Functions | |||
| only returning 1st matching entry in table, need to find next matc | Excel Worksheet Functions | |||
| Matching numbers in an Array and returning values for matched numb | Excel Discussion (Misc queries) | |||
| returning all matching values in column A that have the same value for columnB | Excel Worksheet Functions | |||
| Returning a Value by Matching Two Columns of Data | Excel Worksheet Functions | |||
Threaded Mode
