2.In cell D11, Create a vlookup statement that will generate the same results th
ID: 327641 • Letter: 2
Question
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.
Formula at C11:
=IF(B11=$L$1,$M$1,IF(B11=$L$2,$M$2,IF(B11=$L$3,$M$3,IF(B11=$L$4,$M$4,$M$5))))
2.
Formula at D11:
=VLOOKUP(B11,$L$1:$M$5,2,FALSE)
Then you can copy them to rest of the rows.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.