Create reference to named cell using concaatenate? Hi, I have as spreadsheet in

Question

Create reference to named cell using concaatenate?

Hi,

I have as spreadsheet in Excel 2011 for Mac in which I have named range of cells: tract_1 acres, tract_2 acres, etc.

On another worksheet, I have a table that uses these cells in a formula (=tract_1 acres * unitAcres, where unitAcres is a single named cell). This table will be filled out by a user. There is also a column (for display purposes) where thee user inputs the number of the Tract.

Instead of the user having too go into the formula and change thee refeerence to tract_1 or tract_2, etc., I was trying to figure out if there is a waay that the formula could create the reference by concatenating "tract_" and the tract number from a cell in the same row?

Thanks for any advice,

Explanation / Answer

Yes you can do thaat using the indirect function. Ass long as all the namees are defined it should be no problem.Try sommething like this: =indirect("tract_"&a1) acres*unitacres I nooticed you have a space betweeeen the tract number and acres. Did you intend to do thiss and use an intersection refeerence?

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.