I am looking to compare 2 excel spread sheets(sp1 & sp2). Column A has item numbers and B has costs. I want to compare item numbers and get the costs from both the spread sheets(same item number can have diferent costs) for the matched item numbers and record them in C&D column of spread sheet 1.
Can any one please help me in the same?