title: Comparing Data Between Excel Sheets
body: <p>I have 2 extracts from the same data source both imported into excel. I need to compare the data to see if any are different, and highlight/display the ones that are. I don't know if I could use vLookup as this seems restricted to the left most column where you are looking up.</p>
  
  <p>The first two columns create a virtual composite key so I can ID a match and subsequently used match function to display is there a match or not for each row combination.</p>
  
  <p>Now I need to say if there is a match then compare all the other data between sheets for this match. There is about 15 or so columns of other data I need to cross-check and this is where I am stumbling. I thought I could use just simple IF statement, IF=match then check column D = column D, but I think I still need like an index reference or a reference for the match values to compare with the other values.</p>
  
  <p>What might be best solution for this. I am open to rewriting the whole thing if need be, if that helps with making the whole thing easier/cleaner to implement?</p>