ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula to find cell (https://www.excelbanter.com/excel-discussion-misc-queries/193950-formula-find-cell.html)

Rob_Rad

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

T. Valko

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




Rob_Rad

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





T. Valko

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







Jarek Kujawa[_2_]

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