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