Compare two spreadsheets of different layouts and return mismatched values

Srini96

I have a grid which has rates in excel and the second set of data is pulled form SQL which is the import file manually created from the grid.

Is there any way I can compare the grid with SQL results without manually mapping the two?

Note: The results are being pulled into an excel sheet. 

AbhilashR

Hi @Srini96, just to confirm, you are looking to compare rates value coming from two different datasets? If yes, then I suggest bringing them together in a join tool and looking at the L-J-R outputs to see which ones matched, and which ones did not.