LetsMeasure
New Member
- Joined
- Jul 24, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Suppose I have two excel tables, where TableSmall is a subset of TableBig (TableBig has rows R1-R1) and columns C1-C5. They share some ID column. TableSmall has an arbitrary subset of rows and columns, e.g., rows R5, R6, and R10, columns C3 and C5).
I would like to extract data from TableBig into TableSmall. I can do this using index/match, where I have used helper cells to look up the matching rows an columns, and then get the values in TableBig by using INDEX(TableBig, row I looked up, column I looked up). This approach is shown below.
However, I think there must be a way to do this that doesn't involve helper cells and is probably more elegant. A previous post (How do I refer to the header of this Table Column?) got part of the way there, but it wasn't quite the same question -- and I am having trouble making that example work.
Thanks in advance for any help, and please accept my apologies if I missed a more relevant post.
I would like to extract data from TableBig into TableSmall. I can do this using index/match, where I have used helper cells to look up the matching rows an columns, and then get the values in TableBig by using INDEX(TableBig, row I looked up, column I looked up). This approach is shown below.
However, I think there must be a way to do this that doesn't involve helper cells and is probably more elegant. A previous post (How do I refer to the header of this Table Column?) got part of the way there, but it wasn't quite the same question -- and I am having trouble making that example work.
Thanks in advance for any help, and please accept my apologies if I missed a more relevant post.