how do i set a range within one cell

B

BCBOY

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
 
G

Gord Dibben

Enter in B1 then drag/copy down.

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


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Remove Identical words 0
wrong result Paste within same row while filtered condition applie 1
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Compare two different workbook sheet to show the difference in text 0
Need Help with a VBA subroutine 0

Top