Forum Discussion
Comparing two music libraries
I have an Excel 365 file with 2 sheets. Each sheet consists of info from 2 music libraries on 2 computers. They are listed in tables containing 3 columns (Artist, Track, Album). I want to check if th...
Subodh_Tiwari_sktneerI tried using your method, but every result is NA. I attached a sample portion of my file to the original post.
The problem is that many of the values on the Remote sheet have spaces before and/or after them, but the corresponding values on the Local sheet don't. So they don't match exactly.
You could use
=IF(ISNA(MATCH(TRIM(A3)&TRIM(B3)&TRIM(C3),INDEX(TRIM(Local!$A$2:$A$100)&TRIM(Local!$B$2:$B$100)&TRIM(Local!$C$2:$C$100),),0)),"Missing","")
and
=IF(ISNA(MATCH(TRIM(A2)&TRIM(B2)&TRIM(C2),INDEX(TRIM(Remote!$A$2:$A$100)&TRIM(Remote!$B$2:$B$100)&TRIM(Remote!$C$2:$C$100),),0)),"Missing","")