Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 58
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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