<div>
You're welcome. Glad we could help.
</div>


<div>
<div class="content wysiwyg-content">
Hi Excpert,<br />
<br />
Need Help Of Excel Formula ...INDIRECT Function<br />
i have one sheet M&amp;M and in that sheet Cell Value A2 = 100<br />
i want to Retrieve this value in different sheet and i am using this formula which turn to error &quot;#REF!&quot;<br />
<br />
Formula i am using is this 
<pre><code id="code-10-28964396-1">=INDIRECT(A35&amp;&quot;!A2&quot;)</code></pre>
where A35 = M&amp;M<br />
<br />
Please let me know what to change in formula ?<br />
<br />
Thanks
</div>
</div>


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 (CODE)
where A35 = M&M

Please let me know what to change in formula ?

Thanks

Indirect Function

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.