ExcelBanter - Compare data in two different workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Compare data in two different workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/257219-compare-data-two-different-workbooks.html)

Dave Eade

Compare data in two different workbooks

I've got two workbooks that have similar data that have been extracted from
different sources [ one is MSP the other is an in-house application ].

Both sets of data have similar values in columns [ ie Item ID, Item Status ].

What I want to do is do a compare between the 2 and then list out the
discrepancies between the two tables.

Is this possible?

Thanks

Jacob Skaria

Compare data in two different workbooks

Check out help on VLOOKUP()

--
Jacob

"Dave Eade" wrote:

I've got two workbooks that have similar data that have been extracted from
different sources [ one is MSP the other is an in-house application ].

Both sets of data have similar values in columns [ ie Item ID, Item Status ].

What I want to do is do a compare between the 2 and then list out the
discrepancies between the two tables.

Is this possible?

Thanks

All times are GMT +1. The time now is 06:08 PM.