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