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:

[TABLE="width: 571"]
<tbody>[TR]
[TD="align: right"]6829872[/TD]
[TD]Casa Suba[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3497230[/TD]
[TD]Embajada Suiza[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]3200846[/TD]
[TD]Viejos[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6831002[/TD]
[TD]Diego Fernando[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6260330[/TD]
[TD]Felipe Chavarriaga[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6829872[/TD]
[TD]Casa Suba[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]3497230[/TD]
[TD]Embajada Suiza[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6832274[/TD]
[TD]Diego Orchestra[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]3344912[/TD]
[TD]Casona Centro[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6260330[/TD]
[TD]Felipe Chavarriaga[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6831002[/TD]
[TD]Diego Fernando[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3497230[/TD]
[TD]Embajada Suiza[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6832274[/TD]
[TD]Diego Orchestra[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col span="3"></colgroup>[/TABLE]

 

[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.