If cell is blank pull information from another cell

[BPMWall]

Hi,

I really need help with the following formula. I have 3 columns A1, B1, C1. I need a formula that states if A1, is blank, then go to B1, but if B1 is blank go to C1. Once it pulls the #, then I need the formula to look at that number and if it is greater than 25 "Award 1", if it is greater than 25 but less than 75, "award 2", greater than 75, "award 3"

Appreciate all the help.

 

[Aladin Akyurek]

One of?

1.

="Award "&MATCH(LOOKUP(9.99999999999999E+307,A1:C1),{0,25,75},1)

2.

="Award "&MATCH(LOOKUP(9.99999999999999E+307,CHOOSE({1,2,3},C1,B1,A1)),{0,25,75},1)

 

[metsrule08]

Could you do this in two cells? For example, a column in D stating which number to go with and then:

D1 = IF(isnumber($A1),$A1,if(isnumber($B1),$B1,if(isnumber($C1),$C1,0)))
E1 = IF($D1<=25,"Award 1",IF(AND($D1>25,$D1<75),"Award 2",IF($D1>=75,"Award 3","No Award")))

You could then simply hide column D.

 

[JoeMo]

In D1:

=IF(NOT(A1=""),IF(A1<=25,"Award1",IF(AND(A1>25,A1<75),"Award2","Award3")),IF(NOT(B1=""),IF(B1<=25,"Award1",IF(AND(B1>25,B1<75),"Award2","Award3")),IF(NOT(C1=""),IF(C1<=25,"Award1",IF(AND(C1>25,C1<75),"Award2","Award3")),"")))