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 Contributor Last seen December 27, 2022 - Aug 25, 2022 at 12:22 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Aug 25, 2022 at 12:22 PM
Related:
- Refer to another sheet in excel
- Sheet right to left in google sheet - Guide
- Mark sheet in excel - Guide
- How to screenshot excel sheet - Guide
- Windows network commands cheat sheet - Guide
- How to copy data from one excel sheet to another - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
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