Word-accounting special-currency symbol-&; Olney

2.VLOOKUP function:

Example: According to the book number, please use the VLOOKUP function to complete the automatic filling of the book name in the book name column of the order list worksheet.

Step: Select E3 cell and click Formula-Function Library-Insert Function -VLOOKUP Function.

Excel master skill

3. According to the book number, please enter it in the "Book Name" column of the "Order List" worksheet.

Using VLOOKUP function to complete the automatic filling of book unit price.