Formula to Equal Another Cell Relative to First Cell

[Shiremaid]

Is it possible to have a formula that makes a cell get information from a specific position relative to itself so that even if you add rows it will still look at, for instance, the cell 4 down and two to the right?

Example

I want cell A9 to show the information that is in cell D14 even if I add new rows instead of following the original cell to it's new address at D15.
Is that possible without using a macro?

Thanks

 

[Jonmo1]

Try

=OFFSET(A9,5,3)

 

[Shiremaid]

Perfect, thank you!

 

[Jonmo1]

You're welcome.