Previous Topic Next Topic

Absolute reference from another sheet is not working

Closed
charles273 - Aug 24, 2022 at 05:04 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 25, 2022 at 12:22 PM

I have my First Sheet as an Index sheet with titles of topics and another neath each title i have my latest update which is pulled from another sheet

='Sheet 03'!$B$3 ......For the Title

='Sheet 03'!$B$4......For the update

Every time the I have a new update i am inserting a new row and write the new update

What is happening that in my First Sheet  the update is changing to B5 although i have the $

Can some one suggest a solution? Thanks guys.

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Aug 25, 2022 at 12:22 PM

Hi Charles,

Change your formula:

='Sheet 03'!$B$3

into:

=INDEX(Sheet 03!B:B,3)

Best regards,

Trowa
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses