Prev: open excel file
Next: Look up across multiple sheets
From: Dave Eade on 24 Feb 2010 04:53
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
From: Jacob Skaria on 24 Feb 2010 06:14
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
 | 
Pages: 1
Prev: open excel file
Next: Look up across multiple sheets