Formula help for value grater than 0 placing a name

[Jeremy]

I wanting D1 to show a name if there is a value grater than 0 in B. A 1,2
and 3 always stay the same. If B1 is grater than 0 D1 should say Brown. If
B2 is greater that 0 D1 should say Jill. If B3 is greater than 0 D1 should
say Richard. B 1,2 and 3 will only have one of them grater than 0.


A b c d
1 John 0 Richard
2 Adam 0
3 Sam 2

Thanks

 

[Max]

One way
In D1, normal ENTER:
=INDEX({"Brown";"Jill";"Richard"},MATCH(TRUE,INDEX(B1:B3>0,),0))
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik