is it possible to compare columns of defferent excels with Index and match functions?

[the_observer]

Hi all,

is it possible to compare columns of similar type e.g. products from different excels using the Index and Match functions or they have to be in the same excel?

Example:
I have 2 excels. Each excel has 1 column with product names.
Do i have to merge them in order to use Index and Match functions to compare the columns?

Thank you for your time reading this.

Regards.

 

[SirJB7]

Hi, the_observer!
Give a look at the uploaded files.
The formula used at the Excel1.xlsx workbook is:
=SI.ERROR(COINCIDIR(A2;[Excel2.xlsx]Hoja1!$A$1:$A$6;0);"No") -----> in English: =IFERROR(MATCH(A2,[Excel2.xlsx]Hoja1!$A$1:$A$6,0),"No")
Regards!

 

[the_observer]

I see.
So it is only a matter of syntax to direct the formula to look at the other excel.

Thank you very much for your answer SirJB7.

Regards.

 

[SirJB7]

Hi, the_observer!
Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.
Regards!