Question

Exercise 1 The following shows a portion of an excel worksheet. The table displays the sales for 5 fitness gear product lines broken down by sales associate. Transcribe this information into your workbook. Swimming Lifting Running Climbing Triathalon $ $ $ $ $ Tim 6,500 1,583 400 150 266 John $ 205 $ 630 $ 4,586 $ 20 $1,500 Dawn $ 437 $4,250 $3,125 $5,600 $ 600 Add two input cells to allow a user to enter the product line and associate name. Add an output cell that will output the product line sales by that associate. Use VLOOKUP. Use both IFERROR and data validation as a form of error control on the output cell. Your worksheet only needs to be able to handle a single request for product line/associate information at a time.

Answer 1

X FILE REVIEW 5 er HOME INSERTPAGE LAYOUT FORMULAS DATA % Cut Calibri -11 - A == LE Copy Format Painter BI D A S E HomeworkLib - Microsoft Excel VIEW ADD-INS TEAM Wrap Text General Merge & Center $ % 48 09 D X AutoSum ? - 2 Manish Prasad AY # Sort & Find & Filter - Select Editing Paste Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Fill- Clear Clipboard Font Alignment Number Cells H2 X f =IF(AND(ISNUMBER(MATCH(F2, A2:A6,0)), ISNUMBER(MATCH(G2,B1:01,0))), VLOOKUP(F2,A1:06, MATCH(G2,A1:01,0),FALSE), "Wrong input") A B H Tim Output Input1(Product) Triathalon Input2(Associate Name) John 1500 2 Swimming 3 Lifting 4 Running 5 Climbing 6 Triathalon John $6,500 $1,583 $400 $150 $266 Dawn $205 $630 $4,586 $20 $1,500 $437 $4,250 $3,125 $5,600 $600 Individual Tracker READY O D - SERIES SPONSORED BY + 100% 2:07 AM 3/30/2020 9. Do i futst

Please find the attached screenshot for your refrence

below is the formula that has been applied for output cell

=IF(AND(ISNUMBER(MATCH(F2,A2:A6,0)),ISNUMBER(MATCH(G2,B1:D1,0))),VLOOKUP(F2,A1:D6,MATCH(G2,A1:D1,0),FALSE),"Wrong input")

HomeworkLib did not provide facility to upload the xls file, therefore uploading screenshot

For any concern please leave a comment so that i can reply asap