Merge multiple spreadsheets with common field

Hi I have two spreadsheets with a common field and I need to merge them into a separate third spreadsheet with matching data from both.

I attached an example workbook with simplified sample data.

Sheet 1 has Product_id and SKU fields. Sheet 2 has SKU and Price fields. I need to merge them into Sheet 3 so all three fields are displayed.

Unfortunately in the real data there are literally 8,000+ entries. Roughly 90% of the SKU's are in both spreadsheets, but some SKU's are in one but not the other and visa versa, so sorting, copying and pasting will not work.

I suspect I need the equivalent of IF SKU (Sheet1) = SKU (Sheet2), then print Product_id, SKU and List Price in Sheet 3, but I don't know how to do that in Excel.

Thank you very much for any help you can provide.

Thank you for the help! I'll try both of these with the real data. Hopefully I won't run into any issues, but I may have a follow-up question or two if I run into trouble. Thanks again!