How to match two tables?

Question

excel

Given

Two tables
Each table has its own columns, with its own content (different column names and different content)
Both tables have a column with the same content (ID)
Matching IDs in the tables are on different rows

Question

How to match table rows by ID

Answer 1

The VLOOKUP function will help you, I myself often used it for such a task.
Here is an example: sirexcel.ru/priemi-excel/funktsiya_vpr_v_excel_s_p...