I have a table like this:
A | B | C | D | E |
---|---|---|---|---|
1 | 2 | 3 | 3 | 5 |
5 | 1 | 3 | 2 | 3 |
2 | 2 | 1 | 3 | 3 |
For a given number in the table I want to have get the letter corresponding to the column of the last appearence of the number in some row.
For example 1
will return C
or 2
will return D
.
It seems like XLOOKUP is a good start, but I first need to "flatten" the table into a single row to look into.
Any ideas on that?