tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 377
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
Hi,
I'm trying to grab data from another sheet but not getting the expect result.
The name of the sheet depends on the value in cell V1
=INDIRECT("'WK "&V1&"'!"&C2)
In this case, V1 = 29, then it should go to sheet 'WK 29'!C2 but I get a #REF error
The forumla help thinks I'm trying to read from WK 29 and the value in the current sheet at C2, (='WK 29'!45) which is wrong.
If I change it slightly to
=INDIRECT("'WK "&V1&"'!C2") then it works, however C2 become fixed, which won't drag down to D2, E2 etc.
Please help![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I'm trying to grab data from another sheet but not getting the expect result.
The name of the sheet depends on the value in cell V1
=INDIRECT("'WK "&V1&"'!"&C2)
In this case, V1 = 29, then it should go to sheet 'WK 29'!C2 but I get a #REF error
The forumla help thinks I'm trying to read from WK 29 and the value in the current sheet at C2, (='WK 29'!45) which is wrong.
If I change it slightly to
=INDIRECT("'WK "&V1&"'!C2") then it works, however C2 become fixed, which won't drag down to D2, E2 etc.
Please help