Hi, I have a look up table that looks something like this. 2 columns, lets say in this example a color and company.
RED COMPANY 1
BLUE COMPANY 2
YELLOW COMPANY 3
YELLOW COMPANY4
RED COMPANY 7
BLUE COMPANY 10
BLUE COMPANY11
BLUE COMPANY14
RED COMPANY 20
RED COMPANY 19
PURPLE COMPANY 55
PURPLE COMPANY53
I have a drop down in a dashboard with the colors
RED
BLUE
YELLOW
PURPLE
When a user chooses a color, ALL of the correlating companys need to populate in another tab, and when the color is changed, the same cell would change to a different company. I have about 10-15 companys per color.
If the user chooses RED, then all the REd companies are displayed.
COMPANY 1
COMPANY 7
COMPANY 20
COMPANY 19
I can't do a vlookup, because it will just show the first one in the lookup.
I think I need like a match Product formula?
RED COMPANY 1
BLUE COMPANY 2
YELLOW COMPANY 3
YELLOW COMPANY4
RED COMPANY 7
BLUE COMPANY 10
BLUE COMPANY11
BLUE COMPANY14
RED COMPANY 20
RED COMPANY 19
PURPLE COMPANY 55
PURPLE COMPANY53
I have a drop down in a dashboard with the colors
RED
BLUE
YELLOW
PURPLE
When a user chooses a color, ALL of the correlating companys need to populate in another tab, and when the color is changed, the same cell would change to a different company. I have about 10-15 companys per color.
If the user chooses RED, then all the REd companies are displayed.
COMPANY 1
COMPANY 7
COMPANY 20
COMPANY 19
I can't do a vlookup, because it will just show the first one in the lookup.
I think I need like a match Product formula?