how do i set a range within one cell

[Guest]

Say I have a value eg 23 in one cell i want to use LOOKUP in col A and if it
falls in that range output col b. But how do I set this range in that
cell.Please Help.
eg 23
Col A Col B
row 1 1 - 9 $1
row 2 10 - 19 $2
row 3 20 - 29 $3

 

[Gord Dibben]

Enter in B1 then drag/copy down.

=LOOKUP(A1,{0,9,19},{1,2,3})


Gord Dibben Excel MVP