Trying to lookup dates based on a material and certain date

[Ray167]

Hi, not sure if my title is very clear, but basically I have two columns one with a list of materials and the second with their delivery dates. On a separate spreadsheet I am trying to find the earliest delivery date of a material which is after today's date. The materials usually have been purchased several times with different delivery dates. What combination of formulas can I use to ascertain the delivery date I need?

Thanks in advance.

 

[Ray167]

Bump.

Any distant idea would help me out even.

Thanks