Comparing data with concatenation?

Copper Contributor

Is it it possible to utilize a lookup or match function to search for exact matches of the line data between worksheets, however the lines are not listed in the same order? One sheet is locked the other is not. I want to look up the line data from my work sheet in the locked sheet to compare. 

 

1 Reply

@Laneasze 

=MATCH(TRUE,A3&B3&C3&D3&E3&F3=sheet2!$A$3:$A$13&sheet2!$B$3:$B$13&sheet2!$C$3:$C$13&sheet2!$D$3:$D$13&sheet2!$E$3:$E$13&sheet2!$F$3:$F$13,0)

You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

 

Sheet1:

sheet1.JPGSheet2:

sheet2.JPG