Access table by column name in a cell, and row number specific ranges

[dnaiel]

Hi,

I have an excel table named incomeTable like this:

name	spend	income
mario	3	10
roger	4	5
tom	5	4

<tbody>
</tbody>

I'd want to access a given column and a given range of rows (but getting the column name from a specific cell).

I.e., Let us say I have in A2 the column name of interest

columnNameOfIInterest

spend

<tbody>
</tbody>

Then, how would I access a range of rows and all the contents in that column?
=incomeTable[[1:2],[=$A2]]?
(where A2 is spend)

and it'd return

3

4

<tbody>
</tbody>

 

[Mike Blackman]

Hi,

If you're looking to SUM those values you could use something like this...

=SUM(INDEX(IncomeTable,1,MATCH(A2,IncomeTable[#Headers],0)):INDEX(IncomeTable,2,MATCH(A2,IncomeTable[#Headers],0)))

 

[dnaiel]

Hi Mikey, Thanks. I am not looking to do a sum though, just looking to access a given column and a range of rows. Is that possible using the table format?