| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LookUp (Date) Value from Forecast Data
I need to return the date of when my stock will run out based on the forecast.
LMCode Avail 1-Sep-08 15-Sep-08 29-Sep-08 13-Oct-08 27-Oct-08 10-Nov-08 24-Nov-08 8-Dec-08 22-Dec-08 5-Jan-09 19-Jan-09 2-Feb-09 16-Feb-09 NET001 64,000 36,000 0 0 48,000 0 0 60,000 0 0 0 48,000 0 48,000 Eg: I have 64,000 of Code "NET001" available. Based on the forecast, I need to return the date when my stock will run out. In the above case 13-Oct-08. I've used hlookup =HLOOKUP(I2,AC2:AO2,TRUE) but it only returns the value 48,000. Please can someone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forecast a date from data given | Excel Discussion (Misc queries) | |||
| lookup data betwaeen two date | Excel Discussion (Misc queries) | |||
| how do I fix a forecast date that has passed for a zero value? | Excel Discussion (Misc queries) | |||
| Forecast function and Date option | Excel Worksheet Functions | |||
| How can I Lookup and sum payments for cash flow forecast? | Excel Worksheet Functions | |||
Threaded Mode
