Attached is a quick demo. There are 3 worksheets, the first i the master data list. The next 2 are 2 different scenarios to demonstrate what I want to do.
In Scenario 1, the first item (12345) uses options B and D, so the first footnote would be Option B, the second Option D (as in column C), etc down the line:
1: Option B
2: Option D
3: Option C
4: Option A
In Scenario 2, the first item (12348) uses option A, the second uses option C, so the footnotes would change as follows
1: Option A
2: Option C
3: Option B
4: Option D
I hope this illustrates what I'm trying to do. These footnotes would ultimately be added at the end of the description in column B. Ideally, if I can generate a legend, as I did in rows 11-15, that would be great too, but not as important. And if so, it would be great if it only included the footnotes for options that were used in the list.
Thanks for looking at this. If there's anything else that needs clarification, please let me know.
|