In sheet2, I have the table like this:
In sheet1, I have the table like this:
My goal is to fill the price column in sheet1 using some formulas in excel.
Of course, the expected output of sheet1 should be
But, in my actual data, there are so many rows so that I cannot fill the price column. So, I want to do this using some formulas in excel.
