The so-so way: use MATCH in one column to get the row numbers, INDEX in one column for each column you want to pull in to actually grab them using that row number.
Alternative: join the tables using Power Query so you could have it refresh and give you the combined version even after adding more columns.
I mean, point taken, but in case you were wondering, then yeah.
VBA also does SQL operations on Excel tables, but that's, well, worse.