ExcelBanter - match and sort columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - match and sort columns (https://www.excelbanter.com/excel-worksheet-functions/90895-match-sort-columns.html)

Shamus

match and sort columns

I have 2 worksheets with several columns and the first column in each sheet
is a product code that. Sheet two has more product codes than sheet one but I
want to match the codes that exist in both sheets and then combine the data
in both sheets.
Does this make sense?

All times are GMT +1. The time now is 12:57 AM.