2 Replies Latest reply on Feb 23, 2012 12:10 PM by Xavier P

# Pulling common entries from various lists

Ok peeps, this one is tricky to explain without an example but I will try.

I have 3 lists: x, y and z.

on x, I only want the entries that are also on z.

ditto on y, with z.

so am checking the ATTR on both x and z with a T/F and ditto on y.  They're called check x and check y.

Then I check the both conditions:

IF [checkX] OR [checkY] THEN "Yes"

ELSE "No"

END

I am only pulling entries where x=y=z.

What I am doing wrong?

• ###### 1. Re: Pulling common entries from various lists

Mister X,

I have attached a sample workbook with what I think you want?

Basically, you want to show yes for any matches with Z, is that right? If this is right, look at the match with Z? calculation.

Hope this helps! If not, maybe you can use the data I used and go into more detail about the desired outcome?

-Tracy

• ###### 2. Re: Pulling common entries from various lists

Hi Tracy

You can call me X!

Thanks for that, I will try it out.