Search results for query: *

I figured out the formula =IF(MATCH(A2,A:A,Items!$A:$A),A2,"") but now i need to join that with IF(ISNUMBER(MATCH(CONCATENATE($A2,B$1),Items!$C:$C,0)),"X",""). I tried using an AND statement but I keep on getting an error.

Thank you this does make the X populate wherever the name is. Is there a way that the name can also be automatically added for example, I added a new name to the apple list, I would like it to be automatically added to the MASTER list.

Apples Oranges Peaches Doe, John X Doe, Jane X This is basically the way my MASTER list looks, but with much more users. I have another workbook with a list of all users with apples. What i want to happen is when i enter a name on the list of apples...

Im asking is there a way that I can add a name to the APPLE workbook and that name would be automatically added to the Master workbook

I have a couple of workbooks that i need to link. I have a master list with a bunch of names and on that master list there is a check mark next to an item that the person has. Lets say for example John Doe has an apple, under apples there is a check mark. Now i have another couple of workbooks...