Question: Please help me with the following: I need to insert a lookup function in the column Capacity that looks up the room number, compares it

Please help me with the following:

I need to insert a lookup function in the column "Capacity" that looks up the room number, compares it to the lookup table in the next sheet called "Room Capacity", and returns the room capacity. Can you please help me with the formula?

it to the lookup table in the next sheet called "Room Capacity",

and returns the room capacity. Can you please help me with the

A B C D F F G H K Prefi Cours Section Course Name Day- 1 Start Tim - t End Tim Room Instructor -1 Credi Capaci 11685 BIOL 1010 101 General Biology MWF 7:00 AM 7:50 AM SCI 115 Bergstedt, Jenny A. 3 14261 BIOL 3500 601 Genetics M 6:00 PM 8:30 PM SCI 215 Blaszcak, Adam G 3 19473 BIOL 3515 201 Advanced Genetics Laboratory M 1:00 PM 3:00 PM SCI 215 Bockelman, Travis K. 13822 BIOL 3500 101 Genetics MWF 9:00 AM 9:50 AM SCI 216 Bockelman, Travis K. 3 18790 BIOL 3500 102 Genetics MWF 12:00 PM 12:50 PM SCI 216 Bockelman, Travis K. 3 16745 BIOL 3515 801 Advanced Genetics Laboratory W 6:00 PM 8:00 PM SCI 215 Bockelman, Travis K. 14184 BIOL 1015 102 General Biology Laboratory M 1:00 PM 2:50 PM SCI 210 Ellsworth, Stephen K. 1 18698 BIOL 1615 103 College Biology I Laboratory R 7:00 AM 9:50 AM SCI 210 Ellsworth, Stephen K. 10 19801 BIOL 1015 501 General Biology Laboratory R 6:00 PM 7:50 PM SCI 210 Ellsworth, Stephen K. 11 19859 BIOL 1625 202 College Biology II Laboratory R 12:00 PM 1:50 PM SCI 210 Forester, Joshua Paul 12 11292 BIOL 1625 203 College Biology II Laboratory R 2:00 PM 3:50 PM SCI 210 Forester, Joshua Paul 13 19007 BIO 1625 201 College Biology II Laboratory R 4:00 PM 5:50 PM SCI 210 Forester, Joshua Paul 14 12832 BIOL 1625 204 College Biology II Laboratory T 4:00 PM 5:50 PM SCI 210 Forester, Joshua Paul 15 12948 BIOL 1615 102 College Biology I Laboratory W 7:00 AM 9:50 AM SCI 210 Fredrickson, Cynthia Marie 16 16437 BIOL 1615 106 College Biology I Laboratory W 10:00 AM 12:50 PM SCI 210 Fredrickson, Cynthia Marie 17 15651 BIOL 1010 107 General Biology MWF 9:00 AM 9:50 AM SCI 117 Heaton, Daren N W W H 18 16432 BIOL 4890 104 Student Research TBA TBA TBA TBA Heaton, Daren N 19 15320 BIOL 1010 108 General Biology TR 8:30 AM 9:45 AM SCI 117 Heaton, Daren N 3 20 15531 BIOL 3600 102 Biological Chemistry TR 2:30 PM 3:45 PM SCI 119 Heaton, Daren N 3 21 11724 BIOL 3550 601 Molecular Biology R 7:00 PM 9:30 PM SCI 215 Hughes, Jennifer E. 3 22 16946 BIOL 3555 301 Experiments Molecular Biology T 7:00 PM 10:00 PM SCI 215 Hughes, Jennifer E. 23 12806 BIOL 4890 103 Student Research TBA TBA TBA TBA Hughes, Jennifer E. 24 18554 BIOL 1015 101 General Biology Laboratory M 11:00 AM 12:50 PM SCI 210 Johnson, Edith L. 1 25 19744 BIOL 1010 105 General Biology MWF 9:00 AM 9:50 AM SCI 115 Johnson, Edith L. 3 26 11482 BIOL 1010 113 General Biology MWF 12:00 PM 12:50 PM SCI 115 Johnson, Edith L. - W 27 12258 BIOL 1615 105 College Biology I Laboratory T 10:00 AM 12:50 PM SCI 210 Johnson, Edith L 28 18254 BIOL 1615 108 College Biology I Laboratory T 1:00 PM 3:50 PM SCI 210 Johnson, Edith L. 1 29 11590 BIOL 1610 103 College Biology I MW 1:00 PM 2:50 PM SCI 115 Klopping, Ingrid M. 4 30 18455 BIOL 1610 106 College Biology I MW 4:00 PM 5:50 PM SCI 115 Klopping, Ingrid M. 31 19483 BIOL 1010 114 General Biology MWF 12:00 PM 12:50 PM SCI 117 Klopping, Ingrid M. 32 15639 BIOL 3700 101 General Ecology MWF 8:00 AM 8:50 AM SCI 119 Lawrence, Margarent W W W W W A 33 11711 BIO 1010 102 General Biology TR 7:00 AM 8:15 AM SCI 115 Lawrence, Margarent 34 13505 BIOL 1010 104 General Biology TR 8:30 AM 9:45 AM SCI 115 Lawrence, Margarent 35 18638 BIOL 2500 101 Environment Biology TR 11:30 AM 12:45 PM SCI 119 Lawrence, Margarent 36 15687 RIO 1610 101 College Biology I MTWR 8:00 AM 8:50 AM SCI 117 Martinez. Carlotta37 12136 BIOL 1610 102 College Biology I MTWR 11:00 AM 11:50 AM SCI 117 Martinez, Carlotta 38 19838 BIOL 1010 502 General Biology TR 2:30 PM 3:45 PM SCI 117 Martinez, Carlotta 39 17308 BIOL 4500 101 Principles of Evolution MWE 10:00 AM 10:50 AM SCI 119 Matthews, Cascandra D. 40 18797 BIOL 4500 102 Principles of Evolution MWF 11:00 AM 11:50 AM SCI 119 Matthews, Cascandra D. 3 41 12843 BIOL 1610 501 College Biology I TR 5:00 PM 6:40 PM SCI 115 Matthews, Cascandra D. 42 19754 BIOL 3555 201 Experiments Molecular Biol Lab F 7:00 AM 9:50 AM SCI 214 Naegle, Paul K. 43 13136 BIOL 1010 106 General Biology MWF 10:00 AM 10:50 AM SCI 115 Naegle, Paul K. 3 44 16828 BIOL 1010 111 General Biology MWF 11:00 AM 11:50 AM SCI 115 Naegle, Paul K. 3 45 16849 BIOL 1010 116 General Biology TR 1:00 PM 2:15 PM SCI 117 Naegle, Paul K. 3 46 19160 BIOL 3505 201 Genetics Tutorial F 10:00 AM 10:50 AM SCI 215 Pinkard, Alesha M. 0.5 47 17007 BIOL 3505 202 Genetics Tutorial F 11:00 AM 11:50 AM SCI 215 Pinkard, Alesha M. 0.5 48 19784 BIOL 4890 101 Student Research TBA TBA TBA TBA Pinkard, Alesha M. 2 49 13075 BIOL 1615 110 College Biology I Laboratory W 5:00 PM 7:50 PM SCI 210 Pinkard, Alesha M. 1 50 17973 BIOL 4200 101 Teaching Methods in Science WF 2:30 PM 3:45 PM ED 301 Pinkard, Alesha M. 51 16840 BIOL 4200 102 Teaching Methods in Science WF 4:00 PM 5:15 PM ED 301 Pinkard, Alesha M. H H W W 52 18781 BIOL 1615 107 College Biology I Laboratory F 10:00 AM 12:50 PM SCI 210 Reynolds, Stephanie Beth 53 11320 BIOL 1615 109 College Biology I Laboratory F 1:00 PM 3:50 PM SCI 210 Reynolds, Stephanie Beth 54 13440 BIOL 3405 201 Cell Biology Laboratory M 3:00 PM 5:50 PM SCI 214 Reynolds, Stephanie Beth 55 12015 BIOL 3550 101 Molecular Biology TR 10:00 AM 11:15 AM SCI 215 Reynolds, Stephanie Beth W W H 56 18113 BIOL 1010 501 General Biology TR 7:00 PM 8:15 PM SCI 115 Reynolds, Stephanie Beth 57 13404 BIOL 1610 105 College Biology I MWF 8:00 AM 8:50 AM SCI 115 Sherbotie, Geraldine Mary 58 11485 BIOL 4890 102 Student Research TBA TBA TBA TBA Sherbotie, Geraldine Mary 59 14448 BIOL 1610 104 College Biology I TR 1:00 PM 2:50 PM SCI 115 Sherbotie, Geraldine Mary 4 60 17146 BIOL 1010 115 General Biology MWF 1:00 PM 1:50 PM SCI 117 Siosi, Taulanga 3 61 11178 BIOL 1615 104 College Biology I Laboratory F 7:00 AM 9:50 AM SCI 210 STAFF 1 62 18621 BIOL 3505 203 Genetics Tutorial F 9:00 AM 9:50 AM SCI 215 STAFF 0.5 63 17513 BIOL 1615 111 College Biology I Laboratory F 4:00 PM 6:50 PM SCI 210 STAFF 1 64 14636 BIOL 3505 801 Genetics Tutorial M 8:40 PM 9:30 PM SCI 215 STAFF 0.5 65 16146 BIOL 1615 101 College Biology I Laboratory T 7:00 AM 9:50 AM SCI 210 STAFF 1 66 12672 BIOL 1010 103 General Biology TR 7:00 AM 8:15 AM SCI 117 STAFF 3 67 16342 BIOL 1015 103 General Biology Laboratory W 1:00 PM 2:50 PM SCI 210 STAFF W H 68 19074 BIOL 3400 101 Cell Biology TR 10:00 AM 11:15 AM SCI 214 Sun, Hing 69 14016 BIOL 1010 112 General Biology TR 11:30 AM 12:45 PM SCI 115 Sun, Hing 3 70 13705 BIOL 1010 109 General Biology MWF 10:00 AM 10:50 AM SCI 117 Wagner, Vivian J 71 18861 BIOL 1620 101 College Biology II MWF 1:00 PM 1:50 PM SCI 119 Wagner, Vivian J 72 17020 BIOL 1620 102 College Biology II MWF 2:00 PM 2:50 PM SCI 119 Wagner, Vivian J73 15930 BIOL 1010 110 General Biology TR 10:00 AM 11:15 AM SCI 115 Wagner, Vivian J 3 74 15472 BIOL 3605 202 Biochemistry Laboratory F 10:00 AM 1:50 PM SCI 214 Warburton, Daren Zane 75 19487 BIOL 3605 201 Biochemistry Laboratory F 2:00 PM 5:50 PM SCI 214 Warburton, Daren Zane 76 11867 BIOL 3600 101 Biological Chemistry MWF 9:00 AM 9:50 AM SCI 119 Warburton, Daren ZaneA B C 1 Room Capacity 2 ED 301 30 3 SCI 115 50 4 SCI 117 42 5 SCI 119 28 6 SCI 210 32 7 SCI 214 28 8 SCI 215 24 9 SCI 216 24 10 11 12 13 14 15

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To insert a lookup function to find the room capacity based on the room number you can use the VLOOK... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Mid-Level Exercises 1 Biology Department Teaching Schedule As the department head of the biology department at a university, you prepare and finalize the faculty teaching schedule. Scheduling...

I need help with the following please. Mid-Level Exercises 1 Biology Department Teaching Schedule As the department head of the biology department at a university, you prepare and finalize the...

As the department head of the Biology Department at a university, you prepare and finalize the faculty teaching schedule. Scheduling preparation takes time because you must ensure that you do not...

I need help with these steps. Please be clear in letting me know if I need to highlight the row, or label or both. Also, do I put the function in cell J1 or J2? Insert a lookup function that looks up...

Grader - Instructions Excel 2016 Project EX16_XL_VOL1_GRADER_CAP_HW - Software Training Books 1.8 Project Description: You are a vice president for a publisher of software training books. Your...

Click cell D13 on the Data sheet and Insert a VLOOKUP hat looks up the tour code, 3compares It to the tours table, and retums the descripton. Copy the function down through cell D22. Click cel E13...

Mainly need help with 10 - 26 EX16_XL_VOL1_GRADER_CAP_HW - Software Training Books 1.5 Project Description: You are a vice president for a publisher of software training books. Your division...

Looking for help on a few functions in Excel. A. Click cell E13 and insert a lookup function that looks up the tour code, compares it to the tours table, and returns the departure date. Copy the...

EX16_XL_VOL1_GRADER_CAP_HW - Software Training Books 1.5 Project Description: You are a vice president for a publisher of software training books. Your division publishes three series that focus on...

EX16_XL_VOL1_GRADER_CAP_HW - Software Training Books 1.3 Project Description: You are a vice president for a publisher of software training books. Your division publishes three series that focus on...

The company had 10,000 shares of $1 par common stock outstanding. When each share of stock had a market value of $130, the company decided to reduce the price per share of stock to $65 by doubling...

4. Determine whether or not each of the following statements is true or false, and justify your answer with a proof or a counterexample. (a) (3 points) fr z dz = frdz, where I is the positively...

1 . Under the FD&C Act, as amended by the 2 0 2 2 MoCRA, companies must submit reports to the FDA regarding any adverse events related to cosmetics . a . True b . False

Problem 7-06A a-b (Part Level Submission) Sunland Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2020, the companys Cash account per its...