how to Build a Dragable formula

[beekerdale]

HI,
Im working in Google Sheets and I want B3 to reference B5 all the time.
Should line 5 get deleted, Then I still want the new B5 to be the reference.
And I want to drag the B3 calculation across many columns and have the reference calculation update as I drag it across.

I have been using this formula but it does not update when I drag it to the right. =INDIRECT("B5")
Any tips? Thanks in advance.

 

[Fluff]

Maybe

=INDEX(B:B,5)

 

[beekerdale]

=INDEX(B:B,5)

Oh My! Thank you Fluff! You made me very Happy! Enjoy the day!

 

[Fluff]

You're welcome & thanks for the feedback.