Excel multiple conditional formulas

[micla252]

I need a formula that can perform four possible evaluations in a cell and
return one of four possible answers.
Something like this:

If a2>3 or a2<4.5 return value from aa50
If a2>4.5 or a2<6.5 return value from aa51
If a2>6.5 or a2<8.5 return value fron aa52
If a2>8.5 return value from aa53

Any help would be greatly appreciated

 

[Jacob Skaria]

One way..

=IF(A2<3,"",OFFSET(AA50,LOOKUP(A2,{3,4.5,6.5,8.5},{0,1,2,3}),0,1))

 

[T. Valko]

Try this...

=IF(A2<3,"",INDEX(AA50:AA53,MATCH(A2,{3,4.5,6.5,8.5})))

 

[Faraz A. Qureshi]

In cells z50:z53 insert 3, 4.5, 6.5 and 8.5
Your values are in aa50:aa53

Then, supposing your numbers are in Column A, apply the following formula in
B1 and copy down:
=VLOOKUP(A1,$Z$50:$AA$53,2,1)