value lists

[jl1]

Hi. I know this isn't the right place for this question, but I can't find the right place. So can someone please point me to it.....or just answer the question ...

I have 3 value lists. The first one contains all the values from both of the other lists. When a value is chosen in the first list, I need to search both the other lists and match the value chosen in the first list. Based on which list (2nd or 3rd) I will set a value in another field.

What I'm looking for is something like

if (value1 (match (list1));0

else (value1 (match (list2);1

That's not the right form, but it's something like. What I don't seem to have is a "match"

function.

Can someone help..?/Thanks, Judy

[comment]

I believe you're looking for the FilterValues() function, in conjunction with IsEmpty:

not IsEmpty ( FilterValues ( item ; listofValues ) )

returns true when item is one of the values in listofValues.