Query regarding Relative cell reference

I have 1 question

I used formula in Cell A1 in sheet 1 is =sheet2!B1

But when copy this formula to Cell A15 in sheet1 , it should return to =Sheet2!B2 not =Sheet2!B15

Same for multiples of 15 like cell A30, A45 should return =Sheet2!B3 & =Sheet2!B4 respectively

Is there any way to do that ?

Thanks in advance 😊

By: My friend

Leave a Reply

Your email address will not be published. Required fields are marked *