Stuck. It looks like I'm trying to do a vlookup with the reverse functionality of text join.
My scenario is this.
In sheet 1, I have a column with cells that might contain multiple lines of data, such as:
Action Group
<testers>
<managers>
<supervisors>
*Action group is the Row header (a1), the other 3 lines are in one cell (a2) (ie, Sheet 1, A1, A2)
In sheet 2, I have rows that match each action group in column A (because it can appear multiple times in cells in sheet 1) and their relevant permission in column B, ie;
A1 <testers> B1 yes
A2 <managers> B2 maybe
A3 <supervisors> B3 no
What I need to do in sheet 1 is take the cell with the multiple values and lookup the permissions in sheet 2.
So, in Sheet 1, in the cell next to A2, I would see "yes maybe no" (ideally separated with a comma, or semi colon, etc)
Any help, beyond massively appreciated...
My scenario is this.
In sheet 1, I have a column with cells that might contain multiple lines of data, such as:
Action Group
<testers>
<managers>
<supervisors>
*Action group is the Row header (a1), the other 3 lines are in one cell (a2) (ie, Sheet 1, A1, A2)
In sheet 2, I have rows that match each action group in column A (because it can appear multiple times in cells in sheet 1) and their relevant permission in column B, ie;
A1 <testers> B1 yes
A2 <managers> B2 maybe
A3 <supervisors> B3 no
What I need to do in sheet 1 is take the cell with the multiple values and lookup the permissions in sheet 2.
So, in Sheet 1, in the cell next to A2, I would see "yes maybe no" (ideally separated with a comma, or semi colon, etc)
Any help, beyond massively appreciated...