| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to find cell
I need a formula to read a value in a single cell and use that value to
determine how many cells left to go to retreive a value. For example, cell B3 contains the value 5. the formula in cell L4 would go down 2 rows (static value) and left 5 cells(using the value from cell B3) and retrieve the value in cell E6. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find cell
the formula in cell L4 would go down 2 rows (static value)
and left 5 cells(using the value from cell B3) and retrieve the value in cell E6. From L4: Down 2 rows and 5 columns to the left puts you at cell G6. =OFFSET(L4,2,-B3) -- Biff Microsoft Excel MVP "Rob_Rad" wrote in message ... I need a formula to read a value in a single cell and use that value to determine how many cells left to go to retreive a value. For example, cell B3 contains the value 5. the formula in cell L4 would go down 2 rows (static value) and left 5 cells(using the value from cell B3) and retrieve the value in cell E6. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find cell
Thanks, thats what I was looking for.
"T. Valko" wrote: the formula in cell L4 would go down 2 rows (static value) and left 5 cells(using the value from cell B3) and retrieve the value in cell E6. From L4: Down 2 rows and 5 columns to the left puts you at cell G6. =OFFSET(L4,2,-B3) -- Biff Microsoft Excel MVP "Rob_Rad" wrote in message ... I need a formula to read a value in a single cell and use that value to determine how many cells left to go to retreive a value. For example, cell B3 contains the value 5. the formula in cell L4 would go down 2 rows (static value) and left 5 cells(using the value from cell B3) and retrieve the value in cell E6. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find cell
You're welcome!
-- Biff Microsoft Excel MVP "Rob_Rad" wrote in message ... Thanks, thats what I was looking for. "T. Valko" wrote: the formula in cell L4 would go down 2 rows (static value) and left 5 cells(using the value from cell B3) and retrieve the value in cell E6. From L4: Down 2 rows and 5 columns to the left puts you at cell G6. =OFFSET(L4,2,-B3) -- Biff Microsoft Excel MVP "Rob_Rad" wrote in message ... I need a formula to read a value in a single cell and use that value to determine how many cells left to go to retreive a value. For example, cell B3 contains the value 5. the formula in cell L4 would go down 2 rows (static value) and left 5 cells(using the value from cell B3) and retrieve the value in cell E6. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to find cell
try:
=OFFSET($L$4,2,-B3-2) to retrieve value from E6 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which cell did my formula find? | Excel Discussion (Misc queries) | |||
| find last cell in a column but not a formula | Excel Worksheet Functions | |||
| Is there a formula that can find the cell corresponding to a trans | Excel Worksheet Functions | |||
| Can a formula find a comment in a cell | Excel Worksheet Functions | |||
| Formula to find cell with data on a row | Excel Worksheet Functions | |||
Linear Mode
