VLOOKUP or IF Formula?

[bulmandaniel]

Hi all,

In the process of creating a tool that will calculate Sales Presentation dates when both Launch Date and Launch Markets (multiple selections) are given. Is this possible? I have read up on VLOOKUPs and IF Formulas but they only seem to work for single value inputs, rather than multiple!?

The output (Sales Presentation Date), would need to be based on a particular date range within which Launch Date falls. Timings between Sales Presentation and Launch Date vary between Launch Markets, so output would need to be the earliest possilbe Sales Presentation date based on the Launch Markets that have been selected.

Steps would be:

Image.JPG

1. Input Launch Markets (Multiple Selection via Data Validation) B1 - B5
2. Input Earliest Launch Date B7

3. Output Earliest Sales Presentation Date B9

If somebody could kindly help me out on this, or point me in the right direction, it would be much appreciated.

Thank you!
Dan

[Olly]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[bulmandaniel]

Olly,

Sample workbook attached for reference. Apologies for its basic level. The notes in the workbook should explain the desired outcomes.

Any questions, let me know.

Thanks,
Dan

[Olly]

In cell C2:

Please Login or Register  to view this content.

In cell C3:

Please Login or Register  to view this content.

In cell C4:

Please Login or Register  to view this content.

(slightly different from the two formulae above, as Market 3 varies by month, not by quarter)


In cell B8:

Please Login or Register  to view this content.