| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
| highlight range if cell contains desired data | New Users to Excel | |||
| Grabbing the last Non-empty cell in a range | Excel Discussion (Misc queries) | |||
| Comparing a cell result with a pre-defined value range | Excel Worksheet Functions | |||
| Merging Cells but have each cell counted in the range of merged c. | Excel Worksheet Functions | |||
Linear Mode
