How to look up and return first non zero value?

[zyzz]

I have the following data:

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.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E
1	ID	Output
2	1			1	TextString A
3	1	TextString A		2	TextString B
4	1
5	2
6	2	TextString B
7	2
8
Data

Cell Formulas
Range	Formula
E2:E3	E2	=LOOKUP(2,1/(($B$2:$B$10<>"")*($A$2:$A$10=D2)),$B$2:$B$10)