Help with finding double info in 2 excel tables

[Belinda001]

Hi All,

I have 2 excel tables.
Both tables have 1 kolom that is the same; a reference.
If the reference in the 2 kolom are the same, I want a formula that automatically copy the ID number from 1 table to the other.

Is there a way to do this?

Thanks,
Belinda

[oeldere]

Sheet1

Dutch B2 =INDEX(Export_20200401_102159_TEC.csv!$A$1:$F$137;VERGELIJKEN($A2;Export_20200401_102159_TEC.csv!$F$1:$F$137;0);2) and drag down

Englisch B2 =INDEX(Export_20200401_102159_TEC.csv!$A$1:$F$137,Match($A2,Export_20200401_102159_TEC.csv!$F$1:$F$137,0),2) and drag down

[Belinda001]

thank you so much
just what I needed. works perfectly.

Regards,
B.

[oeldere]

Glad I could help.

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.