tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 385
- 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
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
