2. According to the book number, please use VLOOKUP function to automatically fill in the book unit price in the book name column of the order detail worksheet.

(1.) The cursor is located in the first cell of the Book Name column.

(2) formula-insert function-all functions -VLOOKUP (under the formula, select insert function and VLOOKUP function)

(3) Search value: D3 (the first line in the ISBN)

Data table: All three columns in "Number Cross Reference" are selected.

Column number: 2

Matching condition: false

3. "OK" to complete and fill in quickly.