Populate 1st non-blank in a row

[emack1230]

We are extracted from a path to get a plant name. I have a row range k4:as4 that has a isnumber search formula in every cell to populate one of our plants name. =IF(ISNUMBER(SEARCH(Q$1,$G4)),Q$1,"") We want to pull the plant names from each row into one single column using =INDEX(K4:P4,MATCH(TRUE,INDEX((K4:P4<>0),0),0)). This index fromula works, only if I remove the isnumber search formula from the cells. The index isn't seeing the blank cells a "truly blank" with the formula. We don't think this is to hard but are coming up empty handed on how to pull the first non blank to a single column. Any help would be greatly appreciated.

 

[Sufiyan97]

Try

=INDEX(K4:P4,MATCH(TRUE,INDEX((K4:P4<>""),0),0))

 

[emack1230]

Try

=INDEX(K4:P4,MATCH(TRUE,INDEX((K4:P4<>""),0),0))

That worked perfectly, appreciate the help.

 

[Sufiyan97]

You're welcome.
Glad I could help.