So on an excel sheet, I have a bunch of data, but they are separated into two separate tables.

The first table has two columns, "Name of person" and "ID number", with a bunch of data under that.

The second table has two columns, "ID number" and "Salary", with a bunch of data under that.

The thing is, the order of the ID numbers in the first table is not the same order as the ID numbers in the second table. But what I basically want to do is combine both of these tables into one table with three columns, "Name of person", "ID number" and "Salary". But I'm not sure how I can combine the two tables to do that.

In this new table, I want to keep the order the same as the first table, but I just want to match the ID numbers to the salaries in the third column.

Can someone help me do that?