Return Yes / NO if match in different spreadsheets

[surkdidat]

Good afternoon all

In Spreadsheet 1 (Tab "Sheet1) I have..

Row	Column D - EAN	Column E - Details	Column N - Value
1	12345	Brand	Heinz
2	12345	Colour	Blue
3	12345	Type	Drink
4	12346	Colour	Red
5	12347	Brand	Samsung
6	12347	Type	TV

In Spreadhsheet 2 (Tab - "Entries") I have

Row	Column B - EAN	Column N - Brand	Column O - Colour	Column P - Type
1	12345	Heinz	Blue	Food
2	12346	Rover	Red	Car
3	12347	Samsung	Black
4
5
6

So, what I need to do, in a Spreadsheet 1, Tab 1, is have a YES/NO return if the EAN and Details match,

For Row 1 it looks up EAN 12345 and "Brand". In the 2nd spreadsheet it looks up the EAN in Column B and then looks for the column called "Brand" - where both state "Heinz" it needs to say "YES"

For Row 3, it looks up EAN 12345 and "Type". In the 2nd spreadsheet it looks up the EAN in Column B and then looks for the column called "Type" - where one sheet says "Food" and one says "Drink" it needs to say "MISMATCH"

For Row 6, it looks up EAN 12345 and "Type". In the 2nd spreadsheet it looks up the EAN in Column B and then looks for the column called "Type" - where there is no data, it needs to say "NO"

 

[mumps]

Will the data always be in the columns you indicated in both sheets, for example: Details always in column E, Colour always in column O? Also, in which sheet and in which column do you want to return "YES" and "MISMATCH"?

 

[Fluff]

How about

Fluff.xlsm
	A	B												N	O	P
1		EAN												Brand	Colour	Type
2		12345												Heinz	Blue	Food
3		12346												Rover	Red	Car
4		12347												Samsung	Black
5
6
Entries

Fluff.xlsm
	A	B	C	D	E									N	O
1				EAN	Details									Value
2				12345	Brand									Heinz	Yes
3				12345	Colour									Blue	Yes
4				12345	Type									Drink	No
5				12346	Colour									Red	Yes
6				12347	Brand									Samsung	Yes
7				12347	Type									TV	No
8
Sheet1

Cell Formulas
Range	Formula
O2:O7	O2	=IF(COUNTIFS(Entries!$B$2:$B$100,D2,INDEX(Entries!$N$2:$P$100,,MATCH(E2,Entries!$N$1:$P$1,0)),N2),"Yes","No")