In F3:
=IF(COUNTIF(B3:E3,1)=0,"",INDEX($B$2:$E$2,1,MATCH( 1,B3:E3,0)))
In G3:
=IF(COUNTIF(B3:E3,1)0,IF(LOOKUP(1,B3:E3,$B$2:$E$2 )<F3,LOOKUP(1,B3:E3,$B$2:$E$2),""),"")

Copy down as needed. (Note that MATCH is looking for first instance of "1",
while LOOKUP" is taking last instance. Thus, this can not be simply expanded
to column H to find a third "1")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Redi" wrote:

Hi all,

here is the layout of my spreadsheet:

a3=apple
a4=orange
a5=pear

b2=red
c2=green
d2=yellow
e2=blue

b3=1
c4=1
d5=1
e5=1

f3=formula
f4=formula
f5=formula

g3=formula
g4=formula
f4=formula

column f formula: if there is a 1 on b3:e3, give me the color text
column g formula: if there is another 1 on b3:e3, give me the next
color text

thank you in advance!