| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup part number in a vertical list and return the most recent .
I need to lookup a part number in a "shipment Log" worksheet. It is laid out
with the following column headers: "Part Number" "Aug 1" "Aug 2" "Aug 3" etc.... If a part has been shipped, there will be a value under the appropriate date column. This value will be the quantity shipped. I am trying to find the most recent shipment date and return that date into a cell in another spreadsheet. Does anyone have any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vertical Lookup from a List | Excel Worksheet Functions | |||
| List all contracts that relate to a single part number | Excel Discussion (Misc queries) | |||
| return a range of cells from a vertical lookup | Excel Worksheet Functions | |||
| How to return a dollar value for a part number entered in a cell | Excel Worksheet Functions | |||
| Part Number Lookup | Excel Worksheet Functions | |||
![James T[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
