Multiple sheet look up formula trouble

[spare27]

Hi hi!

I am trying to pull the data from sheets 2 and 3 and consolidate it onto sheet 1 with it appearing only once.

The formula I'm trying is repeating the same info and I don't know how to have it search across multiple sheets. This is a very specific formula so I haven't had a lot of luck finding what I need. :\

Attached is a spreadsheet of what I will be working with essentially.

My formula = IFERROR(INDEX(Sheet2!$A$2:$A$2000, MATCH(0, COUNTIF($B$1:B1,Sheet2!$A$2:$A$2000),0)),0)

Any help is appreciated!

 

[bosco_yip]

Try to use "Consolidate" feature to sum unique value in multiple worksheets without formulas.



In "Sheet1" select A1 >> "Data" >> "Consolidate">>

>> "Function", choose "Sum" >>

>> Click "Browse" >> goto highlight Sheet2!A1:C11 >> press "Add" >>

>> Click "Browse" again >> goto highlight Sheet3!A1:C11 >> press "Add" >>

>> Tick Use labels in : "Top row" and "Left column" >> Click "OK"

Finally become :



Regards
Bosco