I have the following data:
The cells in the output columns are formulae that either return "" or a text string.
I want to look up the ID and return the non-zero/non-"" value in the output column, e.g. lookup ID = 1 and return A.
Have been fiddling around with INDEX MATCH and adding a helper column but can't seem to get anything to work. Any help is much appreciated.
ID | Output |
1 | |
1 | TextString A |
1 | |
2 | |
2 | TextString B |
2 |
The cells in the output columns are formulae that either return "" or a text string.
I want to look up the ID and return the non-zero/non-"" value in the output column, e.g. lookup ID = 1 and return A.
Have been fiddling around with INDEX MATCH and adding a helper column but can't seem to get anything to work. Any help is much appreciated.