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

Sorry I'm not sure I understand what you mean.
I need to display the values of table 1 field 3 based on me knowing table 2 field 1 and I don't see how your suggestion would work.