Compare 2 excel sheets

Hi , 

I am using version 2010.

I have 2 sheets A & B , A with 150 columns and B with 4 columns, 1 column in sheet B have values which are columns in sheets A and i want to compare this 2 sheets and find out differences based upon a common column .

I tried to use pivot tables and don't know how to compare this 2 pivot tables or sheets. 

Appreciate your responses.

Thanks

SS


April 9th, 2015 2:42pm

Have a look a the VLOOKUP-function: http://www.excel-easy.com/functions/lookup-reference-functions.html

Free Windows Admin Tool Kit Click here and download it now
April 12th, 2015 1:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics