Match sorted column values with unsorted column values

[akshay6s]

HI,
i have a data file. in part A there is sorted data alphabetically. and part B is original data unsorted. now i want to compare those all witch each other so that i can be 100% sure that there is not any kind of mismatch.

for example: from part A- ALEXANDER 1 1 120*120 SPL is same in part B or not.

[AliGW]

I don't believe you are still using Excel 2007 - please update your forum profile. Thanks.

[akshay6s]

i am using excel 2007. i have downloaded this file from google sheet. so that i can attach a file here.

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner at the top of the screen. Act on its guidelines and post a SMALL sample sheet, with some manually calculated results.

[PaulM100]

Try: =IF(ISERROR(LOOKUP(2,1/($B$4:$B$4030=I4)/($C$4:$C$4030=J4)/($D$4:$D$4030=K4)/($E$4:$E$4030=L4)/($F$4:$F$4030=M4))),"No Match","Match")

[akshay6s]

WOW!!!! working great. very nicely done. you proved where is a will, there is a way. you are really awesome. thanks again.