Combine 3 tables into 1

[krneki]

Hello,

I'm looking for a formula which would combine 3 tables into one with belonging appropriate values. I believe example in file attached is very self-explanatory since I've also colored cells to match the final table. Perhaps I might mention that Table 1 is basically the source table and contain all existent names. Table 2 and Table 3 are just partial tables and contain only some of the names from Table 1 but not any additional ones.
Please let me know if anything is incomprehensible.

Thanks for help in advance!

Excel_example_table.xlsx

[Ron Coderre]

Welcome to the forum.
Please note that this is a moderated forum, so please take a few minutes to read the forum rules (at the link above).

You'll see that while we discourage posting the same question in multiple forums (because the same talented people frequent multiple forums), we insist that you post links to your other posts in those forums. That way we can monitor progress on them and avoid wasting our time and energy solving problems that are already solved.

I'll post the one link I'm aware of THIS TIME.
http://www.mrexcel.com/forum/excel-q...-into-1-a.html

[Max, Singapore]

a. Do a one time manual effort to "stack" all the tables into one single table via move or cut n paste, with data for each different column header in its own column, except for Name
b. Create a pivot on that one single table
- Drag n drop Name into Row area, drop all the rest of the fields into the Data/Values area (set to Sum)
- Adjust the Data/Values fields placement to suit (Manually move the fields to the left or right)
The above should give you the desired results in a matter of minutes. The pivot will return the unique names listing in the leftmost row, with all the corresponding data in the desired Data/Value fields
------------------------------------
Works? Wave it, hit the little star at the bottom left of my responses

[FDibbins]

If you copy the headings from the 2 tables to your mail table...
Value 1 Amount 1 Value 2 Amount 2

Then you can use this for Value1 copied to Amt 1...
=IFERROR(INDEX($A$17:$C$24,MATCH($A4,$A$17:$A$24,0),MATCH(C$3,$A$17:$C$17,0)),"")
and this for the other 2...
=IFERROR(INDEX($A$28:$C$35,MATCH($A4,$A$28:$A$35,0),MATCH(E$3,$A$28:$C$28,0)),"")
Copy all 4 cells down