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.

First enter "=vlookup? It will be displayed as a picture.

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, to find what you need in that area. 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.