Hello, I'm looking for some advice on the correct way to build a new table from two existing tables. Each table has a column that appears in the other , but there may be some duplicates

examlpe

table 1
col1 col2 col3
a b 234
b e 274

table 2
col5 col6 col7
z c 234
v e 245


new table
col ( if col3 and 7 the same ) col1 col2 col5 col6

I hope this is clear enough for someone to point me in the right direction . I have managed to sort out match function to identify where the entries apper by row number but a new sheet would be much neater ..
regards ecosse