Forum Discussion
How to attach specific dates to a specific category that is in the dropdown menu??? Help !
I notice that you have all the items for your dropdown list written in the Source-field of the Conditional Formatting dialogue box. It's better to create a list of all items in a separate sheet and then create a reference to that list in the Source-field. And then you can add the logic that SergeiBaklan was aiming at. You need to determine the date to be attached to each Category yourself. Once that has been accomplished, it's easy to fill in the date, based upon the selected Category.
I've attached a revised version of your sheet to demonstrate the principle. It uses Structured Tables and the VLOOKUP function to find the dates. In case your Excel version recognises the new XLOOKUP function, you could try the following formula in column K of the first sheet. It will produce the same result, but with more flexibility.
=XLOOKUP([@Category],Table1[Category],Table1[Submission Date],"",0)If this is not the kind of logic you had in mind, please clarify your intentions.
Riny_van_Eekelen Also, each "Retailer" have different dates for each of the categories listed; would I create a "Categories" tab for each retailer so the dates populate properly? If so how do I link each category tab to the individual retailer?
Example: Fresh Thyme Farmers Market "Aromatherapy" submission deadline is 4/2/20 but Sprouts Farmers Market "Aromatherapy" submission deadline is 6/10/20 .
NeedHelp1015 Not sure now if every retailer has different data for every single category. Have aded a column for "Retailer" in the Category sheet. Would it be feasible to enter all the possible dates there? If not every retailer has every category you can simply leave them out.
It will be quite a job, I believe. From there, we can take the next step and set the dates for each category based on retailer.