Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Copy the formula in cell M7 to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the
Copy the formula in cell M7 to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the label in column L.
A B C H I J K L M N O P Q R s D E - F G Tallridge Regional Medical Center Staffing and Financial Summary by Department Staff Support MD RN Total Turnover Department summary 33 o Abbreviation Department 6 CCU Coronary Care 7 EMR Emergency 8 END Endocrinology 9 ICU Intensive Care 10 NEU Neurology 11 OBS Obstetrics 12 ONC Oncology 13 RAD Radiology 14 Total Turnover % 2021 Budget 14% $ 5,250,768 29% $ 18,782,039 0% $ 2,847,592 9% $ 9,282,172 3% $ 5,283,109 7% $ 11,010,924 47% $ 12,448,265 11% $ 10,927,453 15% $ 75,832,322 % change from 2020 5.20% 9.30% 0.20% 2.30% -1.50% 3.30% 6.10% 1.20% 3.26% Abbreviation ICU Department Intensive Care MD RN Support 15 Total Turnover Turnover % 10.092592593 2021 Budget 9282172 % change from 2020 0.023 VLOOKUP($M$6,$A$6:$J$13,2,FALSE) VLOOKUP($M$6,$A$6: $J$13,3,FALSE) VLOOKUP($M$6,$A$6:$J$13,4,FALSE) VLOOKUP($M$6,$A$6:$J$13,5,FALSE) VLOOKUP($M$6,$A$6:$J$13,6,FALSE) VLOOKUP($M$6,$A$6: $J$13,7,FALSE) VLOOKUP($M$6,$A$6:$J$13,8,FALSE) VLOOKUP($M$6,$A$6: $J$13,9,FALSE) 54 17 8 106 37 293 VLOOKUP($M$6,$A$6: $J$13,10,FALSE) Last update Today's date 5/13/2021 3/29/2020 In Cell M7, VLOOKUP is referenceing cell M6 "CU" for its search of range A6:J13 (absolute). The information being returned to cell M7 is from column 2 (spreadsheet column B on the staf table) from row 9 "ICU" You can see to the right of the Department Summary, I have typed the formulas with the red numbers being the column in the ICU row The numbers in column M match the numbers from row 9 "ICU" A B C H I J K L M N O P Q R s D E - F G Tallridge Regional Medical Center Staffing and Financial Summary by Department Staff Support MD RN Total Turnover Department summary 33 o Abbreviation Department 6 CCU Coronary Care 7 EMR Emergency 8 END Endocrinology 9 ICU Intensive Care 10 NEU Neurology 11 OBS Obstetrics 12 ONC Oncology 13 RAD Radiology 14 Total Turnover % 2021 Budget 14% $ 5,250,768 29% $ 18,782,039 0% $ 2,847,592 9% $ 9,282,172 3% $ 5,283,109 7% $ 11,010,924 47% $ 12,448,265 11% $ 10,927,453 15% $ 75,832,322 % change from 2020 5.20% 9.30% 0.20% 2.30% -1.50% 3.30% 6.10% 1.20% 3.26% Abbreviation ICU Department Intensive Care MD RN Support 15 Total Turnover Turnover % 10.092592593 2021 Budget 9282172 % change from 2020 0.023 VLOOKUP($M$6,$A$6:$J$13,2,FALSE) VLOOKUP($M$6,$A$6: $J$13,3,FALSE) VLOOKUP($M$6,$A$6:$J$13,4,FALSE) VLOOKUP($M$6,$A$6:$J$13,5,FALSE) VLOOKUP($M$6,$A$6:$J$13,6,FALSE) VLOOKUP($M$6,$A$6: $J$13,7,FALSE) VLOOKUP($M$6,$A$6:$J$13,8,FALSE) VLOOKUP($M$6,$A$6: $J$13,9,FALSE) 54 17 8 106 37 293 VLOOKUP($M$6,$A$6: $J$13,10,FALSE) Last update Today's date 5/13/2021 3/29/2020 In Cell M7, VLOOKUP is referenceing cell M6 "CU" for its search of range A6:J13 (absolute). The information being returned to cell M7 is from column 2 (spreadsheet column B on the staf table) from row 9 "ICU" You can see to the right of the Department Summary, I have typed the formulas with the red numbers being the column in the ICU row The numbers in column M match the numbers from row 9 "ICUStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started