Hello everyone,
The excel sheet I'm working on consists of dependent drop-down lists, category, subcategory and resolution. Now let's say we choose "Inquiry" in category list and "Policy" in the subcategory, the "Inquiry > Policy" related options will appear in the following column of resolution.
Now we have "Inquiry > Policy" path and also "Complaint > Policy" path which have different related options but we need to name both lists with different options, "Policy", so that the INDIRECT function will recognize it. How do I do that?
Thank you.
Bookmarks