Hi,
I have an excel table named incomeTable like this:
<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
<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
<tbody>
</tbody>
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>