Comparing two files intruducing comments

[riverad]

Hi Guys, how are you all doing? Im fine
A Quick question, i have two different files with the following:

File 1:

Has phone numbers and on the right side of the phone number is also the name of the entity.

File 2:

In the second file, i have only the phone numbers, and i need some formula, so that if the phone
number appears on both files, the cell on the right side should automatically fill up with its name.

Example:

6829872	Casa Suba			3497230	Embajada Suiza
3200846	Viejos			6831002	Diego Fernando
6260330	Felipe Chavarriaga			6829872	Casa Suba
3497230	Embajada Suiza			6832274	Diego Orchestra
3344912	Casona Centro			6260330	Felipe Chavarriaga
6831002	Diego Fernando			3497230	Embajada Suiza
6832274	Diego Orchestra

<tbody>
</tbody><colgroup><col><col><col span="2"><col span="3"></colgroup>

 

[Gavin T]

You can do this by using the VLOOKUP function.

Place this formula in File2 cell B1 "=IFERROR(VLOOKUP(A1,[File1.xlsm]Sheet1!$A$1:$B$7,2,0),"")"

Replace the red text with your workbook name

Replace the blue text with the data range in File1

Although this will create a link between the two file which may lead to future issues.