Calculating values from different sheet

[szpt9m]

Hi All,

Straight to the point!!

I have a workbook with 3 sheets each having 2 columns!

Please Login or Register  to view this content.

Now i need to search in all 3 sheets, if column A value of one sheet matches with another sheet, then i need to sum the values in column B. if it doesnot matches then i just need take those values and put it in my resultant sheet.

so the result from the above example will be as below:

Please Login or Register  to view this content.

Since here the first value in column A of sheet 1 matches with that of sheet 2, the values in column B is summed up.. all other values are placed as it is..

Thank you,

[JBeaucaire]

Read up on Multiple Source Pivot Table reports:

http://office.microsoft.com/en-us/ex...010226585.aspx

http://www.contextures.com/xlPivot08.html

[szpt9m]

it is not a pivot table.. i need an excel formula to get the desired output

[JBeaucaire]

I'm pointing you to the solution to the question. A single formula to do what you've stated is huge and cumbersome and unnecessary. Read the tutorials, it shows you exactly how to easily get the resultant output you've noted using a Multiple Range Pivot table. That's what it was written for.

[SDCh]

you can use 3-D reference, read this:
http://www.myonlinetraininghub.com/e...ple-worksheets

[JBeaucaire]

AS SDCh has demonstrated for me (and I've used that very site/technique to do it), you CAN do it with cumbersome, complex formulas like that. My point still stands, it's completely unnecessary and requires you to pull out all the "codes" to put in your resultant report. A Multiple Range/Sheet Pivot Table is simpler to create and will create all the codes for you.

[SDCh]

As JBeaucaire said Pivot table is simpler to create and will create all the codes you need

I just show you that you can use that formula