• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

Indirect Function

Hi Excpert,

Need Help Of Excel Formula ...INDIRECT Function
i have one sheet M&M and in that sheet Cell Value A2 = 100
i want to Retrieve this value in different sheet and i am using this formula which turn to error "#REF!"

Formula i am using is this
=INDIRECT(A35&"!A2")

Open in new window

where A35 = M&M

Please let me know what to change in formula ?

Thanks
0
Naresh Patel
Asked:
Naresh Patel
  • 2
2 Solutions
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Try this......

=INDIRECT("'"&A35&"'!A2")

Open in new window

0
 
ProfessorJimJamCommented:
INDIRECT("'"&A35&"'!"&"A2")
0
 
Naresh PatelTraderAuthor Commented:
Thanks
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad we could help.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now