Hi everyone,
I have 2 seperate table on 2 different sheet:
- a Cube Pivot Table
- a table that I paste from another source
Both table have a in Column A, an ID that is unique value for each row.
I need to merge these 2 table in a new table.
1st table (Cube pivot Table)
<tbody>
</tbody>
2nd table
<tbody>
</tbody>
The result of this merge would like to have is the following
<tbody>
</tbody>
I do not know how, but I managed to make a Vlookup of the 2nd table with following formula: (DATA is the name of the pivot Table)
=VLOOKUP(A2,DATA,3,0)
=VLOOKUP(A2,DATA,4,0)
=VLOOKUP(A2,DATA,5,0)
When I try to do the same for the Cube pivot data, formula is returning #N/A. I tried also with following formula but is returning 0
=IFERROR(INDEX(DATA,MATCH($A2,sheet1!$A:$A,0),2),0)
I tried to see if the formatting is the same but it looks that everything is fine.
Any help please?
Thank you in advance
I have 2 seperate table on 2 different sheet:
- a Cube Pivot Table
- a table that I paste from another source
Both table have a in Column A, an ID that is unique value for each row.
I need to merge these 2 table in a new table.
1st table (Cube pivot Table)
1000 | jack | x | 2016 | Q2 | MAY |
1001 | Jack | b | 2016 | q2 | JUL |
1003 | MARK | X | 2018 | Q1 | JAN |
1004 | CHLOE | V | 2017 | Q3 | SEP |
1005 | MEL | F | 2018 | Q1 | FEB |
<tbody>
</tbody>
2nd table
1000 | Jack | 5 stars | Russia | Moscow |
1201 | ||||
1341 | ||||
1001 | ||||
1100 | ||||
1004 | CHLOE | 4 Stars | China | Shangai |
<tbody>
</tbody>
The result of this merge would like to have is the following
1000 | jack | 2016 | q2 | may | 5 stars | Russia | moscow |
1004 | chloe | 2017 | q3 | sep | 4 stars | China | Shangai |
<tbody>
</tbody>
I do not know how, but I managed to make a Vlookup of the 2nd table with following formula: (DATA is the name of the pivot Table)
=VLOOKUP(A2,DATA,3,0)
=VLOOKUP(A2,DATA,4,0)
=VLOOKUP(A2,DATA,5,0)
When I try to do the same for the Cube pivot data, formula is returning #N/A. I tried also with following formula but is returning 0
=IFERROR(INDEX(DATA,MATCH($A2,sheet1!$A:$A,0),2),0)
I tried to see if the formatting is the same but it looks that everything is fine.
Any help please?
Thank you in advance