Thread: 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!

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

If you capitalize the word "days" in Q10, then you can use:

=I3+SUBSTITUTE(VLOOKUP(IF(ISNUMBER(MATCH(H3,$P$3:$P$10,0)),H3,"All Others"),$P$3:$Q$10,2,0),"Days","")

copied down.

Even better, just leave numbers in column Q to represent number of days and use:

=I3+VLOOKUP(IF(ISNUMBER(MATCH(H3,$P$3:$P$10,0)),H3,"All Others"),$P$3:$Q$10,2,0)

Hello, See the attached.

Change the customers days & All others in a new sheet, So you can add/delete customers from the list.

Originally Posted by butterfly123

Perfect...thanks!! I tried both ways and like Abi's.

I appreciate both!!

You did ask for shipping date the other respondent gave you number of shipping days.... semantics, I guess ....