Excel Formula Help

[harvw]

Hi Guys,

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

If any of the cell values in one row (from cells A2 to BB2) in sheet 2 equal the values in any of the rows in sheet 1(from cells A2 to BB2) then I would like to return the values 'TRUE' or 'FALSE' for each cell that is being compared. Please note there are only 200 rows in sheet 2 and 400 rows in sheet 1 so the formula will need to search through the entire 400 rows of data in sheet 2.

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.

Your help on this would be greatly appreciated!

 

[FDibbins]

This sounds like a question I have already answered on another thread?

 

[FDibbins]

Yup, this is a duplicate thread to this 1, which you already have responses to...
https://www.mrexcel.com/forum/excel...match-comparison-between-multiple-sheets.html