Good evening,
Sheet2 looks like this:
| Column A | Column B | Column C | Column D | Column E |
Row 1: | Company A | Red | Blue | Green | Yellow |
Row 2: | Company B | | Blue | | Yellow |
Row 3: | Company C | Red | | Green | |
Row 4: | Company D | Red | Blue | | Yellow |
On Sheet1, I want a drop-down list that shows Companies that have the value Red
Then i want another drop-down list, that shows Companies that have the value Blue.
And so on.
I've looked at dependant drop-down lists, and these are dependant, but Sheet2 needs to be set out the way it is, and i've not seen any examples that look like my sheet!
Any help, greatly appreciated.
Best regards
manc
Sheet2 looks like this:
| Column A | Column B | Column C | Column D | Column E |
Row 1: | Company A | Red | Blue | Green | Yellow |
Row 2: | Company B | | Blue | | Yellow |
Row 3: | Company C | Red | | Green | |
Row 4: | Company D | Red | Blue | | Yellow |
On Sheet1, I want a drop-down list that shows Companies that have the value Red
Then i want another drop-down list, that shows Companies that have the value Blue.
And so on.
I've looked at dependant drop-down lists, and these are dependant, but Sheet2 needs to be set out the way it is, and i've not seen any examples that look like my sheet!
Any help, greatly appreciated.
Best regards
manc
