Searching multiple columns in a row for data

[markwhite]

HHi

I want to seach a row looking for any data over 9 columns. There are more than 120 rows so I just drag this formula down the column that I want the answer to apear in.

The follow works for some rows but not all? I get #Name for the columns that don't provide the correct result.

=IF(F4*TRUE,F4,IF(G4*TRUE,G4,IF(H4*TRUE,H4,IF(I4*TRUE,I4,IF(J4*TRUE.,J4,IF(K4*TRUE,K4,IF(L4*TRUE,L4,IF(M4*TRUE,M4,IF(N4*TRUE,N3.IF(O4*TRUE,O4))))))))))

I am sure that there would be a more elegant solution... HELP PLEASE.

 

[forginganewone]

Yes there are easier ways, can you show sample data please.
I couldn't really get what you are trying to ask.

 

[Peter_SSs]

The follow works for some rows but not all? I get #Name for the columns that don't provide the correct result.

=IF(F4*TRUE,F4,IF(G4*TRUE,G4,IF(H4*TRUE,H4,IF(I4*TRUE,I4,IF(J4*TRUE.,J4,IF(K4*TRUE,K4,IF(L4*TRUE,L4,IF(M4*TRUE,M4,IF(N4*TRUE,N3.IF(O4*TRUE,O4))))))))))

The reason for the error is the dot after the highlighted True.

See if this does what you want. If not, please show some sample data as requested. Several rows would be better than one and also tell us what results you want for those rows.

=IFERROR(INDEX(F4:O4,MATCH(TRUE,INDEX(ISNUMBER(F4:O4),0),0)),"")

 

[markwhite]

The reason for the error is the dot after the highlighted True.

See if this does what you want. If not, please show some sample data as requested. Several rows would be better than one and also tell us what results you want for those rows.

=IFERROR(INDEX(F4:O4,MATCH(TRUE,INDEX(ISNUMBER(F4:O4),0),0)),"")

Thanks you.... works fine.

 

[Peter_SSs]

Thanks you.... works fine.

You're welcome. Thanks for letting us know.