How to make it so that when entering information in a cell, additional information is added to the right?

Question

Google Chrome

Hello, I want to make it so that in a new sheet, when adding a surname, a phone number is added on the right, and this information comes from another sheet.
Here, for example, I have Sheet 1 - it stores a table in which there are surnames and a phone number.
in Sheet 2 I want to display a list. I enter the last name in the cell and at the same moment the phone number appears on the right.
How can this be implemented? Working in Google Excel

Answer 1

In Excel, you can make a VLOOKUP function