1

Click the space G3 in the Unit Price column, and then select Insert Function under the Formula tab to open the Access Function dialog box.

2

Select the VLOOKUP function in the dialog box. If you can't find it, you can enter the function name in "Search Function" and click "Go". You can see the function you are looking for in Select Function, and then click OK. The function parameter dialog box pops up.

three

We insert the book unit price according to the book number in the book pricing table (sheet2).

Stop the cursor in the lookup_value preselection box, and the unit price "BookNoD3" column, D3 will appear in the lookup_value.

four

Place the cursor in table_array, select sheet2, and then select A3:C 19 table.

five

Col_index_num indicates the number of columns in the table (SHEET2) to be searched. This is in the third column, so enter 3.

six

Enter "TRUE" in Range_lookup.

seven

Click OK to get "G3 column display 36". When you put the mouse in the lower right corner of G3 cell and a black lion box appears, drag the cursor down until you finally get all the data.