Schopenhauer
New Member
- Joined
- Jun 15, 2015
- Messages
- 4
I've been trying to use INDEX and MATCH to get this done, but I can't create an output in the format I'm trying to accomplish.
Here's what I'm trying to do (apologies for the cruddy formatting):
Black White Red Orange Yellow
Chevy 200 400 500 390 122
Ford 400 300 450 700 500
Dodge 410 600 800 400 600
VW 600 400 775 210 450
Toyota 500 444 890 400 610
Here's what I'm trying to accomplish:
Output Desired:
Black Chevy 200
Black Ford 400
Black Dodge 410
Black VW 600
Black Toyota 500
White Chevy 400
White Ford 300
White Dodge 600
*
*
*
*
Yellow Dodge 600
Yellow VW 450
Yellow Toyota 610
Basically, I need a list that will compile all date in order, in one long column. Is this even possible? I've been researching this for a couple days now, and can't find anything that can quite get it to work. Maybe using HLOOKUP and MATCH? Not sure how to solve this one.
Thank you!
-Brad
Here's what I'm trying to do (apologies for the cruddy formatting):
Black White Red Orange Yellow
Chevy 200 400 500 390 122
Ford 400 300 450 700 500
Dodge 410 600 800 400 600
VW 600 400 775 210 450
Toyota 500 444 890 400 610
Here's what I'm trying to accomplish:
Output Desired:
Black Chevy 200
Black Ford 400
Black Dodge 410
Black VW 600
Black Toyota 500
White Chevy 400
White Ford 300
White Dodge 600
*
*
*
*
Yellow Dodge 600
Yellow VW 450
Yellow Toyota 610
Basically, I need a list that will compile all date in order, in one long column. Is this even possible? I've been researching this for a couple days now, and can't find anything that can quite get it to work. Maybe using HLOOKUP and MATCH? Not sure how to solve this one.
Thank you!
-Brad
Last edited: