Please help!
I have a table with column headers (a,b,c) and row footers (x,y,z):
I'm trying to lookup up all instances of each number in the table, and return text that would concatenate the corresponding footer values with the corresponding header values:
Example 1:
- if I searched for 1's, I would expect the text: "x z a, y b"
Example 2:
- if I searched for 2's, I would expect the text: "x b, y z c"
Example 3:
- if I searched for 3's, I would expect the text: "x c"
Can this be done? If so, how?
Thanks!
I have a table with column headers (a,b,c) and row footers (x,y,z):
a | b | c | |
1 | 2 | 3 | x |
1 | 2 | y | |
1 | 2 | z |
I'm trying to lookup up all instances of each number in the table, and return text that would concatenate the corresponding footer values with the corresponding header values:
Example 1:
- if I searched for 1's, I would expect the text: "x z a, y b"
Example 2:
- if I searched for 2's, I would expect the text: "x b, y z c"
Example 3:
- if I searched for 3's, I would expect the text: "x c"
Can this be done? If so, how?
Thanks!