Hi All,

I'm working on a Forecast vs. Actual Income project of inventory that comes into a company. My issue is that there is a huge list of Materials, each with an ID that are supposed to come in (Forecast), paired with this material ID is an expected Due Date.

So I set up a simple VLOOKUP, and now my issue is that when it looks up the material ID it is only returning the first Due Date as that is the date that corresponds to the material ID.

It looks something like this

203010 1/2/15
203010 1/2/15 (when this date should be 1/12/15)

Any ideas how to get the Lookup to retrieve the 2nd, 3rd, 4th etc. date that corresponds with the Material ID?

Let me know if any of this doesn't make sense

Thanks for any help.