Single entry in a list

[HWL]

This one should be simple. Say I have formulas in range E2:E6. In one of those spots I will return text, and only one. Or all of them could be blank.

I need another formula in A6 that simply displays whatever was returned in the range of E2:E6.

The problem being, that the text returned in E2:E6 is so dynamic, I can't think how to use index or match. Help? Thanks

 

[HWL]

this one should be simple. Say i have formulas in range e2:e6. In one of those spots i will return text, and only one. Or all of them could be blank.

I need another formula in a6 that simply displays whatever was returned in the range of e2:e6.

The problem being, that the text returned in e2:e6 is so dynamic, i can't think how to use index or match. Help? Thanks

answered my own question:

=index(f2:f6,match(true,len(f2:f6)<>0,0),1) cse

 

[pgc01]

Hi

Another option, not cse:

=LOOKUP(2,1/LEN(F2:F6),F2:F6)