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.

CodePudding user response：

I have created such a Sheet1:

I have created such a Sheet2, where the value of B2 is equal to =VLOOKUP(A2,Sheet1!A$2:B$5,2,FALSE), and this is the result: