Hi all,
Would love some help with this INDEX/LOOKUP/MATCH displaying information issue I am struggling with.
I have a 3x3 Display Table into which I will place formulas:
DISPLAY
Input cell (E1): name
A B C
1
2
3
I have 3 x 3x3 'People' Tables
John
A B C
5 XYZ
6 YZX
7 YYZ
Peter
A B C
9 TUV
10 UVT
11 TTV
Paul
A B C
13 MNO
14 OON
15 MOO
When the name is entered into the input cell E1, I want the information from the cells in that corresponding persons table to appear in the Display Table.
When a different name is entered the displayed data would change.
I am happy to add some 'helper' cells in order to make this happen, I just can't get my head around the indexing that may be necessary.
Thanks so much all.
Bookmarks