I have a list of items with attached attributes. Each has more than one attribute, and there are a lot of attributes, so each alike attribute does not have its own column. I would like to have a second chart return the item’s name when the condition is listed.
Goal: please help me find an equation that returns the title of the row if the condition appears in any column
EX:
| Title | A 1 | A 2 | A 3 |
|--------|-----|-----|-----|
| First | xxx | xxy | xyx |
| Second | yxx | xyy | yyx |
| Third | yxy | yyy | xxz |
| Fourth | xzx | zxx | xzz |
Then a second chart that basically goes:
| Attribute | Title |
|-----------|-------|
| xxy | First |
| yyy | Third |
| xxz | Third |
If it has multiple matches, I really only care about the first one/that there is one. I have tried multiple things like MATCH and XMATCH but they don’t do multiple columns. The best I came up with was =COUNTIF(ARRAYFORMULA(A1=D:E),TRUE)>0), where A is the criteria and D:E is the attribute columns. The problem is it doesn’t return the title, which I kind need it to do.
Thanks!
