Basic INDIRECT formula Question

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I have sheet headings in column A, those are numbers, and I want the formula to read the corresponding cell in column A and bring the description of that sheet from cell A1 of each sheet.
I am using, "=INDIRECT("'"&A23&"'!"&$A$1), that does the job, but I do not want to reference $A$1. I want to make it static. Meaning I want that in the formula rather than reference to cell A1, where I put A1.

Thanks

 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

ghrain22

Active Member
Joined
Jan 9, 2014
Messages
473
=INDIRECT(A23&"!&A1")

If I'm understanding your question correctly, you just need to put your A1 in qoutes so that it's read as a string instead of a reference. The string will concatentate and THEN the indirect turns that string into a reference.
 

srizki

Well-known Member
Joined
Jan 14, 2003
Messages
1,791
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Thank you very much, Yes it worked.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,545
Messages
5,529,458
Members
409,879
Latest member
Aussie_Excel_Wanna_Be
Top