Attached is a workbook that has two lists with about the same data. Given that they are not a one for one on the same row, I need to do a "lookup" and compare the values, relating to columns A & G with the values found in columns D and J.
Example: If Column A8 and G? are the same, then look at D8 and J? to see if they are comparable. If the values are different, then that needs to be shown somehow, or there could be a True/ False next to the values in column D, if that would be best.
What is the best way to perform a lookup and compare?