Merge two tables using formulas only

Hi, I've been doing some Excel exercises recently, but I'm stuck on this one.  Is it possible to fill in the table in Sheet1 with information from Sheet2, but without using power query, just formul...