Formula to find cell

[Rob_Rad]

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]

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)

 

[Rob_Rad]

Thanks, thats what I was looking for.

From L4:

Down 2 rows and 5 columns to the left puts you at cell G6.

=OFFSET(L4,2,-B3)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thanks, thats what I was looking for.

 

[Jarek Kujawa]

try:

=OFFSET($L$4,2,-B3-2)

to retrieve value from E6