Solved

Indirect Function

Posted on 2016-08-19
4
43 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 29

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 29

Expert Comment

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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Select only certain columns not entire sheet 12 28
Auto Populate Day Month  2 digit Date 4 19
locking multiple column ranges 10 24
And OR formula 5 22
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…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

773 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