Is it possible to reference a cell in Microsoft Excel using its renamed row and column?-CodePudding

In a spreadsheet I'm making for my Thermodynamics class, I created an appendix with important values for certain molecules, such as the molar mass of Ethane. I have renamed the rows to the molecule names and columns to the important variables.

I want to be able to simply type some version of =Ethane_molarmass or something like that to call the specific cell. Is this possible, and how?

CodePudding user response：

Assuming you have named the column molarmass and the row ethane, you can simply get the intersecting value using this formula:

=ethane molarmass

CodePudding user response：

Try:

=INTERSECT(ColumnRangeName, RowRangeName)

or without the named ranges, for example,

=INTERSECT(B:B,2:2)  for the value in Col B, Row 2

or dynamically (not ideal):

=INTERSECT(INDIRECT("ColumnRangeName"),INDIRECT("RowRangeName"))