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