Imagine you are working with patient accounts in your medical office. There are hundreds and thousands of patients. You need to quickly find information for a specific patient account balance. Now that you have the basic knowledge of VLOOKUP, create a table using the following steps and the VLOOKUP function. Make sure to follow each step carefully and exactly as stated:
Enter the data below into cells A1 to B9. Don't forget to leave cells A2 and B2 blank. This is where the VLOOKUP function will be displayed.
Make sure the data is in ascending order. Click on cell B2. This is where the data results will be displayed.
On the Ribbon, Click on the Formulas tab and Choose Lookup & Reference; scroll down to VLOOKUP in the list.
In the dialog box, click on the Lookup_value line.
Click on cell A2 in the worksheet to enter the cell reference into the dialog box. This is where you will enter the patient name for which we are seeking information.
In the dialog box, click on the Table_array line.
Highlight the data in the table to enter the range into the dialog box. The table_array is the table of data that VLOOKUP searches for the lookup_value specified in cell A2.
In the dialog box, click on the Col_index_num line and type the number 2. This indicates that the data we want returned is in column 2 of the table_array.
In the dialog box, click on the Range_lookup line and type the word False. This indicates that we want an exact match for our requested data.
Click OK.
In cell A2 of the worksheet, type Miller, Russ and click the tab key to advanced to cell B2.
The value $1,748.50 should appear in cell B2 displaying the account balance of Russ Miller as indicated in the table_array.
You should see the complete function displayed in the formula bar =VLOOKUP (A2, A4:B9, 2, FALSE).
Enter your name in the bottom left footer.
Save your work as Week10_(first initial of your name and your last name).
