Calculate End Date based on value assigned to String and user-input Start Date

Hello Excel Experts!

I've had a search around and not having much luck finding an answer to my query, although I must admit I ain't exactly sure how to phrase my search terms.

Col. A = Text (An Event)
Col. B = Start Date (User Input)
Col. C = End date (Generated)

There is a variety of Events, with different durations, but those durations do not change, but their Start Date does.

The ultimate goal is simply to select your event and start date and have excel return the end date.

Any help is hugely appreciated!

The end date could be simply calculated with =B2+10

Where 10 is the designated duration in days.

If you wanted that duration somehow 'automatically' calculated, you'd need a table on your sheet somwhere that tells the formula which duration applies to each event..
Say F2:G10

F2:F10 = Event Names
G2:G10 = Corresponding Durations

Then use
=B2+VLOOKUP(A2,$F$2:$G$10,2,0)

Works like a charm! Thank you!

You're welcome.