Excel Vlookup or MATCH Comparison Between Multiple Sheets

[harvw]

Hi Guys,

Does anyone know how I can lookup the values in one row in sheet 2 (see tables below) and compare this with all rows in sheet 1?

If any of the cell values in one row in sheet 2 equal the values in any of the rows in sheet 1 then I would like to return the values 'TRUE' or 'FALSE' for each cell that is being compared.

Additionally I want to create a separate column which returns either TRUE if all of the values in one row within sheet 2 equal ALL of the values in any row in sheet 2 or else FALSE.

And for sheet 3 I was thinking of being able to do exactly the same thing as I did for sheet 2 but with mismatched columns.

Your help on this would be greatly appreciated!

sheet 2

id	cd	name	rating	number	client
1032444	913	ethe	low	33	ybr
9103452	242	nab	high	77
7783455	455	roshe	medium	50	mac
2489990	899	stry	low	90
1345662	231	iot	high	40	nre
1345662	231	iot	high	90	med

<tbody>
</tbody>

sheet 1

id	cd	name	rating	number	client
1032444	913	ethe	medium	40
1032444	913	ethe	high	23
1032444	913	ethe	low	33	ypr
9103452	242	nab	high	77
7783455	455	roshe	medium	50	mac
2489990	899	stry	low	90
1345662	231	iot	high	35
1345662	231	iot	high	90	med

<tbody>
</tbody>

sheet 3

name	rating	number	id	client	cd
ethe	low	33	1032444	ypr	913
nab	high	77	9103452		242
roshe	medium	50	7783455	mac	455
stry	low	90	2489990		899
iot	high	40	1345662	nre	231
iot	high	90	1345662	med	231

<tbody>
</tbody>

 

[harvw]

For that, just do a countif(range,TRUE) and compare with a COUNTA() of the same range?

Apologies for the basic question here but can you please explain this using an example? ie, the range I will be searching is from cells A2 to F2 for about 100 rows down and so the range is A2-A100, B2, B100, C2, C100 etc. and I'm comparing with any and all rows in a different sheet.

 

[FDibbins]

It just keeps returning 0. It is not returning true or false.

What does the formula you used here, look like?