I need a formula which will look up values between 3 different columns to produce one result.
I've attached the excel & I specifically need the answer for the question no 4:Complete the missing information in the yellow cells using formulas.

Could someone solve the problem for me & explain which formulas to use here.Excel test - Copy.xlsx