Address for Excel table cells

0
votes

I have a table HP_175 that has headers one of which is NOx. In a cell outside the table if I start a formula (=) and click on the header cell I get this address.

=HP_175[[#Headers],[NOx]]

How do I address the cells in the rows in the NOx column?

I tried replacing '#Headers' with a row number - didn't work.

1
excelexcel-formula
support.office.com/en-us/article/… - Scott Craner

1 Answers

1
votes

To reference the seventh row (including the header),

=INDEX(HP_175[[#All],[Nox]], 7)

To reference the seventh row (not including the header),

=INDEX(HP_175[Nox], 7)