vlookup vs Match+index

[Giancar]

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)

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

 

[Leandroarb]

Hi,

In the place of DATA, you write the name of range (Column) where are the data.

=IFERROR(INDEX(Column,MATCH($A2,sheet1!$A:$A,0),2),0)

 

[Giancar]

Hi,

Still 0!

 

[Leandroarb]

Do you writing the range that you need on the result?

 

[SpillerBD]

The Index is looking at a different Table/Range than the Match?

 

[Giancar]

The Index is looking at a different Table/Range than the Match?

Yes. Do you think it will help me getpivotdata?
@Leandro: I have tried range J2:J500000 and also J:J but still 0.

 

[Giancar]

Hi,

#N/A was the result because one was a number and the other column wasn't. I just added a 0 to the Vlookup formula and I have solved the issue.
thank you