So I have a SharePoint List that contains a column that holds a special ID. Let's call it orderNumber. Then I have 2 other columns (lets call one Car and the other Color).
Now, both these columns are empty but the orderNumber column already contains numbers. Now my Excel table contains the data that needs to be placed in the car and color columns.
So, for example, in my SharePoint list lets say 1 is in the orderNumber. In the Excel table, we have three columns (orderNumer, car, color) and it would contain 1, ford, red.