Hi, I'm having trouble extracting some data.

Table 1
field 1 field 2 field 3
1 a Fred
2 b John
3 c Paul

Table 2
Field 1 field 2
1 a,b
2 b,c
3 a,c


So table 2 field 2 are comma delimited values.
Each value relates to table 1 field 2.

If I know Table 2 field 1, I want to display table 1 field 3.

My current plan is to convert the string to an array and then make a loop that extracts each element of table 2 field 2 from the array and somehow equates that element to table 1 field 2 to then derive table 1 field 3.

Am I on the right track? Is this even possible in formula workshop?

Any suggestions would be grateful. Apologies if I've not made myself clear.
James