completing ship to dates based on customers name and table of values

I have attached a copy of my workbook. I am trying to determine ship dates for my customer based on the customers name (this has been changed to A,B,C, etc for privacy) and the order dated. I have approx 150 customers, but only 15 have a specific date and all others are 7. Could you recommend a formula? I thought an 'if' formula would be too lengthy.

Thanks for your input!