Lookup comparison

[iamtheclient20]

Hello,

Example I have 2 lookups, first.csv and second.csv

first.csv have 1 column name=fruit_name and with multivalue

first.csv

fruit_name

apple
banana
melon
mango
grapes
guyabano
coconut

second.csv have 2 column fruits and remarks with multivalue under fruits column

fruits	remarks
apple mango guyabano	visible

How can i check if all the values of second.csv (apple,mango,guyabano) are present in the column fruit_name under first.csv then echo out the remarks with the value of visible

Thanks in advance

[ITWhisperer]

how have you set up your csv files so that they have multivalue fields?