Excel 2007 : Trouble Returing Correct Date

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.

If anyone needs this for future help:

The way I was able to solve this was by putting a lot identifying number on each material ID that was supposed to come in-->

Formula was this:

=A1&"-"&COUNTIF(B$1:B1, B1)

Where the B column is the material description for the Material ID

This way each time the material was ordered, the lookup went back to the specific entry and looked at it's individual date.

Cheers,
Rob