Reference no: EM13752312
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).
|
A constant friction force present between the floor
: Mary applies a force of 79N to push a box with an acceleration of 0.47 m/s2.When she increases the pushing force to85N,the box's acceleration changes to 0.73 m/s2. There is a constant friction force present between the floor
|
|
What is the mean and standard deviation
: What is the mean and standard deviation (SD) for preoperative T score for CVLT Acquisition - distribution of scores for the postoperative CVLT Retrieval T scores is normal, the middle 68% of the patients had T scores between what two values?
|
|
What are some faster ways to accomplish data collection
: Data collection takes a lot of time. Therefore, it is not worth the time and trouble. What do you think? What are some faster ways to accomplish data collection
|
|
Write a speech outline for a global and national problem
: Write a persuasive speech outline for a global, national, regional, state or local problem that apparently exists because humans in general or a specific group of humans are neglecting their duty.
|
|
Find information for a specific patient account balance
: 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
|
|
Determine the after-tax lowest euac of the equipment
: Now Mary is looking at the remaining 5 years of her investment in this equipment, which she had initially evaluated on the basis of an after-tax MARR of 25% and a tax rate of 35%. Assume that the replacement repeatability assumption are valid. Det..
|
|
Describe how the division addresses customer needs
: Propose a new product or service for the new company division. The division should be customer-focused with an innovative mission statement. Ensure that you are differentiating your product or service. Describe how the division addresses customer n..
|
|
Quarterly demand for flowers at a wholesaler
: Quarterly demand for flowers at a wholesaler are as shown. Forecast quarterly demand for year 5 using: 1. simple exponential smoothing with α=0.1 2. using Holt's model with α=0.1 and β=0.1
|
|
Identify the one primary strength
: Create a SWOTT table summarizing your findings. Your environmental analysis should consider, at a minimum, the following factors. For each factor, identify the one primary strength, weakness, opportunity, threat, and trend, and include it in your ..
|