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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 25, 2022 at 12:22 PM
Related:
- Refer to another sheet in excel
- How to screenshot excel sheet - Guide
- How to copy data from one sheet to another in excel automatically - Guide
- How to open excel sheet in notepad++ - Guide
- Excel date format dd.mm.yyyy - Guide
- Mark sheet in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Aug 25, 2022 at 12:22 PM
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