According to the book number, please use vlookup function to complete the automatic filling of the book unit price in the book name column of the order list worksheet. The corresponding relationship between "book title" and "book number" is in the book number comparison worksheet.

Enter "=vlookup" first, and the figure will be displayed.

The first step is to find the book title according to what, that is, according to the book number, enter the grid and comma of the book number, as shown in the figure.

Step two, where to go, that is to say, go to that area to find what you need. The corresponding relationship between "book title" and "book number" is in the book number comparison worksheet. So go and number the chart area of the worksheet.

Step 3, the book name is in the second column of the area. You should fill in a comma of 2, then match it accurately and press enter.

At this time, it has been automatically filled.

When it's lit, drag it down.