| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup, one row down
Hi,
I have a large database in an Excel file containing order information. I need to match delivery times from this database with some estimated production times per order number. In some cases there are two delivery times but the order number in the databsae is the same. Does anyone have an idea on how to also get the other delivery time, which always is found on the row under the first desired row. Kind of Vlookup(a1;Range;Row;0)+1 -- Tomas S |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Threaded Mode
