How to fulfill such a condition?

Question

Google Sheets

Here is an example: https://docs.google.com/spreadsheets/d/186rSfqTvDR...

It is necessary to check if there are names from one column in another column, and if so, substitute the corresponding values ​​in another column.

Example: First column Sasha , Victor

The second column contains information that Sasha has a monitor. It is necessary to substitute the monitor in the first column for Sasha.

Answer 1

You need VLOOKUPeg
=INDEX(IFERROR(VLOOKUP(A1:A8;D1:E4;2;0)))

Example in Spreadsheet https://docs.google.com/spreadsheets/d/1xGKClhD7M6...

Answer 2

You can use the VLOOKUP function.
An example of its use can be found on the Internet, for example, the article https://topgoogle.ru/rukovodstvo-po-funkcii-vpr-vl...