Solved

Indirect Function

Posted on 2016-08-19
4
38 Views
Last Modified: 2016-08-19
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
Comment
Question by:itjockey
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 400 total points
ID: 41762733
Try this......

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

Open in new window

0
 
LVL 25

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 100 total points
ID: 41762734
INDIRECT("'"&A35&"'!"&"A2")
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 41762901
Thanks
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41762904
You're welcome. Glad we could help.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now