I have a table that I need to populate it’s results on a cleaner page, is there any way I can have it pull the cells to display based on the contents of one cell?
For example Cell X contains A, so it pulls the results for cell Ay-Az.
I have a table that I need to populate it’s results on a cleaner page, is there any way I can have it pull the cells to display based on the contents of one cell?
For example Cell X contains A, so it pulls the results for cell Ay-Az.
To pull a range of values, use an array formula. For example, start with the following contents for Sheet1.
A B C
~~~ ~~~ ~~~~
a h o
b I p
c j q
d k r
e l s
f m t
g n u
And this for Sheet2.
A B
~~~~~~~~~~ ~~~~
column B
start row 3
end row 6
address
In cell B4 of Sheet2, enter the following formula to produce Sheet1.B3:B6
.
=CONCATENATE("Sheet1.";B1;B2;":";B1;B3)
Finally, enter the following array formula in cell D1 and press Ctrl+Shift+Enter
.
=INDIRECT(B4)
The result:
D
~~~~
j
k
l
m