Question

13. Enter a formula in cell M7 using the VLOOKUP function to find an exact match...

13. Enter a formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column).

Homework Answers

Answer #1

The formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column) :

M7=VLOOKUP( $M$6, $A$6:$J$13, 2, FALSE )

VLOOKUP takes as inputs :

1. The value to be matched - Here we use absolute reference for the cell M6

2. The table array range to look for the value - Here we use absolute reference for the staff table (the range A6:J13)

3 -The column value to returns - Here we are returning the department name (2nd column)

4 -Exact or Approximate match - Here we use Exact match (FALSE)

VLOOKUP search for the exact value in cell M6 in the first column of the table , A6:J13 and returns the 2nd column value for the matched row and store in M7.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Excel searches for an exact match of the first argument in the first column of the...
Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is a. EXACT. b. TRUE. c. FALSE. d. NULL. The function of Trace Precedents and Trace Dependents is to a. highlight errors in copying and formula construction. b. investigate the cell calculations in great detail. c. ascertain how model parts are segregated. d. trace the range of cells included in the Watch Window box list.
In cell B7, enter a formula without using a function to determine the profit generated at...
In cell B7, enter a formula without using a function to determine the profit generated at the Downtown location by subtracting the store’s expenses (cell B6) from the store’s sales (cell B5) for the week of March 1-7, 2018. Copy the formula you created in cell B7 to the range C7:D7.
Enter a formula in cell B9 using the IFS function to calculate the owner's draw from...
Enter a formula in cell B9 using the IFS function to calculate the owner's draw from the company. If the value in cell B7 is greater than or equal to 500000, the draw amount is 50000. If the value in cell B7 is greater than or equal to 150000, the bonus is 5000. If the value in cell B7 is less than 150000, display the text "no draw".
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT