Date output from changing cell range

[kolonel]

Hey guys,

Just trying to work the logic to output dates for a sheet i am using for stock arrivals.

As its setup, i have a list of customers with various amounts of the same product, with an ETA for arrival down 1 column.

At the bottom of my sheet, i have purchase orders for various quantities, and ETA. This date can change on a weekly basis, and i want it to automatically update the ETA cells for the customers if i modify the purchase order date.

I was looking at the if/then function, but thought it might be best to get a little guidance from the guru's.

Thanks in advance.

Regards

 

[kolonel]

I was looking at the if/then function, but thought it might be best to get a little guidance from the guru's.

Looks like the vlookup function might be better served.

 

[kolonel]

Using Excel 2010, and ere is an example of the layout i am working with.