Ok, I don't think what I'm trying to do is unique, but I certainly can't seem to work it out or find any examples, or even failing that, think of a better way.
Sheet One contains cells with Action Groups. These cells might have one action group per cell, or multiple action groups per cell, such as:
In Sheet Two, the action group values are defined in Column A, and in Column B, a list of permissions, which are separated by ><
What I would like to do in Sheet One is use VLOOKUP or similar to look at that cell, see each of the action groups within it, then output the permissions associated with each of those action groups found in Sheet Two. Ideally one formula to cover both scenarios (of one action group per cell, and multiple action groups per cell), but if I have to have different formulas, then that's OK.
Obviously at the moment =VLOOKUP(R71,'Sheet2'!$A$2:$B$25,2,FALSE) works for singular cell items, the other cells return NA.
Thanks so much in advance for any help or advice.
Sheet One contains cells with Action Groups. These cells might have one action group per cell, or multiple action groups per cell, such as:
In Sheet Two, the action group values are defined in Column A, and in Column B, a list of permissions, which are separated by ><
What I would like to do in Sheet One is use VLOOKUP or similar to look at that cell, see each of the action groups within it, then output the permissions associated with each of those action groups found in Sheet Two. Ideally one formula to cover both scenarios (of one action group per cell, and multiple action groups per cell), but if I have to have different formulas, then that's OK.
Obviously at the moment =VLOOKUP(R71,'Sheet2'!$A$2:$B$25,2,FALSE) works for singular cell items, the other cells return NA.
Thanks so much in advance for any help or advice.