![]() |
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 |
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 |
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 |
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 |
Formula to find cell
try:
=OFFSET($L$4,2,-B3-2) to retrieve value from E6 |
All times are GMT +1. The time now is 10:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com