Lookup Date Value from forecast data

[bamma]

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/3 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/3" 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?

[Richard Buttrey]

Hi, and welcome to the forum.

One way is to use a 'helper' row. In AC3 enter:

Please Login or Register  to view this content.

and copy across to AO3

now the formula:

Please Login or Register  to view this content.

will return 13 Oct 2008 (obviously you'll need to format it as a date rather than a number).

HTH