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