Lookup Values, but only for values that are in common with all column entries?

[DarkJester89]

Color coding is not part of the formula, just did it for easy reference

Trying to find a lookup value formula for E1 column, to look in Column A:C to return values that are only common in all of them.

I don't have a "in common" table like in col e, I'm trying to populate it.

I've spent the last few hours trying to figure something something related but nothing.

It checks Col A for item 1, is this item in col B, yes, in col c, yes? Ok move it col E, until all items are looked up.

If item 1, isn't in col b, it moves to item2 in col A.

Is this possible? Thanks in advance!

Workbook:

 

[Fluff]

How about

Look Up Values.xlsx
	A	B	C	D	E
1	Person 1	Person 2	Person 3		In Common
2	Apple	Orange	Apple		Apple
3	Orange	Melon	Orange		Orange
4	Banana	Apple	Kiwi		Banana
5	Water	Lemon	Pineapple		Kiwi
6	Cherry	Kiwi	Banana
7	Lime	Banana
8	Kiwi	Lime
Sheet1

Cell Formulas
Range	Formula
E2:E8	E2	=IFERROR(INDEX($A$2:$A$8,AGGREGATE(15,6,(ROW($A$2:A8)-ROW($A$2)+1)/(ISNUMBER(MATCH($A$2:$A$8,$B$2:$B$8,0)))/(ISNUMBER(MATCH($A$2:$A$8,$C$2:$C$8,0))),ROWS(E$2:E2))),"")

 

[DarkJester89]

Wow, that's awesome, thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.