how do i set a range within one cell
 

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

Enter in B1 then drag/copy down.

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


Gord Dibben Excel MVP

On Sat, 14 May 2005 09:57:10 -0700, "BCBOY"
wrote:

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