1. In cell C11, Create a nested if statement to look up the Sales Rep for each r
ID: 2508387 • Letter: 1
Question
1. In cell C11, Create a nested if statement to look up the Sales Rep for each region that is found in cells L1:M5. Copy and paste the formula down through the rest of the database.
2.In cell D11, Create a vlookup statement that will generate the same results that were found using the nested if statement in the previous question. Copy and paste the formula down through the rest of the database.
Inset Dw Page Layout Formulas Data Review View Hep Tel mewhet File Calbr Dh Copy Calculation Form at Panter B 1 u % , |-8-2 | Conditional Format as check Cell Linked Cell Note Formatting Table East SouthWhitman Sofvino Nested Rep IF Unit Cost Total Cost Total ? ? Sheetsheet2Sheet3 - O Type here to search 99 09 29 39 49 59 $ 79 89 eek 99-99-99 00 99 99-99-99-99 29 99 99 9-99 3 3 3 20-3 00 95-9 en al al -al-al aa -ra-ra-ra -ra 1 2 om 12 13 14 15 16 17 18 19 21 22 23 24 25 20 27-28 29 31 32 34 35 36 37 38 39 40 41 42 43 4 5 78Explanation / Answer
1. In cell C11
=LOOKUP(B11,$L$1:$L$5,$M$1:$M$3)
Copy C11 to remaining C Row.
2.In Cell D11
=VLOOKUP(B11,$L$1:$M$5,2,FALSE)
Copy D11 to remaining D Row.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.