Hello,
I need a formula that matches the value in one column by searching through the values of multiple columns with the result being the column heading of the matching column.
EXAMPLE
1 2 3 4 5 6 Matching Column Result Heading #
Aqua Red Gold Ivory Purple Yellow Aqua 1
Aqua Red Gold Ivory Purple Yellow Aqua 1
Aqua Red Gold Ivory Purple Yellow Aqua 1
Aqua Red Gold Ivory Purple Yellow Aqua 1
Red Aqua Ivory Gold Purple Yellow Above All 0
Red Aqua Ivory Gold Purple Yellow Above All 0
Red Aqua Ivory Gold Purple Yellow Above All 0
Red Aqua Ivory Gold Purple Yellow Above All 0
Red Aqua Ivory Purple Yellow Gold Ivory 3
Red Aqua Ivory Purple Yellow Gold Ivory 3
Red Aqua Yellow Ivory Purple Gold Yellow 3
Red Aqua Yellow Ivory Purple Gold Yellow 3
Red Aqua Yellow Ivory Purple Gold Yellow 3
The formula resides in Result Heading# column and is the matching the value in the Matching Column with one of the columns numbered 1 -6 and the result is the heading of the matching column.
If the Matching Column equals "Above All" the result is zero [0].
Row 1 Matching Column equal "Aqua" column 1 equals "Aqua", so the result is 1 the columns heading for "Aqua".
Please see spreadsheet for a better understanding. Examples of what the value should be have been manually entered.
Any and all help you could provide for any of the formulas would be greatly appreciated. Thank you.
Bookmarks