All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Ask a Question
Sign In
Register
FREE Trial
Find
Study help
Business
Finance
A B C D E F G H Region
A B C D E F G H Region Midwest Question 4: Use VLOOKUP to find...
See Answer
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A B C D E F G H Region Midwest Question 4: Use VLOOKUP to find price in column H and use XLOOKUP to find per unit discount in column I. Calculate net revenue in column J. Use VLOOKUP or XLOOKUP to find region in column K Sales Rep Anderson, Robin Date Units Sales Rep Product Price Per Unit Disco Net Region 12/17/2017 5 Nichols, Claudia Quad B Bryan, Viola West 6/24/2016 6 Bryan, Viola Quad B Gonzalez, Danny East 1/25/2016 35 Rodgers, Bob Sunbell Miles, Josefina Southwest 3/21/2017 3 Rodgers, Bob Sunshine 5 Ply 1 Nguyen, Sheldon East 5/31/2017 2 Nichols, Claudia Northwest 8/13/2017 3 Pittman, Otis West 5/2/2016 67 Rodgers, Bob 4 Richardson, Kristin, Northwest 1/9/2016 15 Rodgers, Bob Midwest 10/31/2017 16 Stokes, Taylor 17 Boomerangs 18 Available 19 Quad 20 Bellen 21 Carlota Southwest 8/27/2016 51 Anderson, Robin 11/23/2017 10 Stokes, Taylor2 Price 9/9/2017 $34.48 5/13/2017 $27.78 9/6/2016 $19.76 4/21/2016 22 Carlota Doublers $58.18 2/27/2016 5 Gonzalez, Danny 43 Gonzalez, Danny 5 Rodgers, Bob 70 Gonzalez, Danny 57 Pittman, Otis 23 Majestic Beaut $22.04 2/11/2016 24 Sunshine 5 Ply $15.40 8/11/2016 5 Stokes, Taylor 39 Stokes, Taylor 5 Richardson, Kristina Quad 3 Gonzalez, Danny Sunset 3 Richardson, Kristina Carlota Doublers 2 Richardson, Kristina Sunbell Quad Sunset Bellen Dancer Carlota Doublers Bellen Wind Dance Sunbell Majestic Beaut Sunbell Quad Flattop 25 Sunshine 10 Ply $20.50 7/19/2016 26 Sunset $23.50 11/21/2016 27 Sunbell $29.10 9/23/2016 121 Miles, Josefina 5 Rodgers, Bob 62 Gonzalez, Danny Sunbell Sunshine 10 Ply 28 Flattop $24.72 7/7/2016 29 Bellen Dancer $28.16 5/16/2017 30 Bellen Wind Dancer $30.32 6/13/2017 31 GelFast $25.80 3/29/2017 9 Gonzalez, Danny 2 Gonzalez, Danny 64 Anderson, Robin 4 Rodgers, Bob Quad Quad Sunbell Majestic Beaut Quad 32 Phenolic Sunshine $31.24 4/2/2016 33 Icarus MTA $37.36 3/9/2016 34 2/3/2017 35 Units Price Per Unit Discount 9/25/2017 36 0 $0.00 7/4/2016 37 10 $0.02 12/5/2017 10 Bryan, Viola 38 15 $0.10 6/21/2016 39 25 $0.35 7/3/2017 40 44 $0.45 9/24/2016 41 75 $0.50 1/9/2016 42 100 $0.55 2/23/2017 10 Nichols, Claudia 37 Gonzalez, Danny 58 Bryan, Viola 8 Richardson, Kristina Quad 5 Gonzalez, Danny Quad 3 Gonzalez, Danny 56 Gonzalez, Danny 1 Nguyen, Sheldon 51 Gonzalez, Danny 37 Miles, Josefina Carlota Doublers Sunbell Carlota Quad Bellen Wind Dance Quad Sunbell Sunbell Quad 43 8/20/2016 5 Anderson, Robin Quad 44 5/16/2016 1 Gonzalez, Danny Quad 10/2/2016 4 Richardson, Kristin Sunset A B C D E F G H Region Midwest Question 4: Use VLOOKUP to find price in column H and use XLOOKUP to find per unit discount in column I. Calculate net revenue in column J. Use VLOOKUP or XLOOKUP to find region in column K Sales Rep Anderson, Robin Date Units Sales Rep Product Price Per Unit Disco Net Region 12/17/2017 5 Nichols, Claudia Quad B Bryan, Viola West 6/24/2016 6 Bryan, Viola Quad B Gonzalez, Danny East 1/25/2016 35 Rodgers, Bob Sunbell Miles, Josefina Southwest 3/21/2017 3 Rodgers, Bob Sunshine 5 Ply 1 Nguyen, Sheldon East 5/31/2017 2 Nichols, Claudia Northwest 8/13/2017 3 Pittman, Otis West 5/2/2016 67 Rodgers, Bob 4 Richardson, Kristin, Northwest 1/9/2016 15 Rodgers, Bob Midwest 10/31/2017 16 Stokes, Taylor 17 Boomerangs 18 Available 19 Quad 20 Bellen 21 Carlota Southwest 8/27/2016 51 Anderson, Robin 11/23/2017 10 Stokes, Taylor2 Price 9/9/2017 $34.48 5/13/2017 $27.78 9/6/2016 $19.76 4/21/2016 22 Carlota Doublers $58.18 2/27/2016 5 Gonzalez, Danny 43 Gonzalez, Danny 5 Rodgers, Bob 70 Gonzalez, Danny 57 Pittman, Otis 23 Majestic Beaut $22.04 2/11/2016 24 Sunshine 5 Ply $15.40 8/11/2016 5 Stokes, Taylor 39 Stokes, Taylor 5 Richardson, Kristina Quad 3 Gonzalez, Danny Sunset 3 Richardson, Kristina Carlota Doublers 2 Richardson, Kristina Sunbell Quad Sunset Bellen Dancer Carlota Doublers Bellen Wind Dance Sunbell Majestic Beaut Sunbell Quad Flattop 25 Sunshine 10 Ply $20.50 7/19/2016 26 Sunset $23.50 11/21/2016 27 Sunbell $29.10 9/23/2016 121 Miles, Josefina 5 Rodgers, Bob 62 Gonzalez, Danny Sunbell Sunshine 10 Ply 28 Flattop $24.72 7/7/2016 29 Bellen Dancer $28.16 5/16/2017 30 Bellen Wind Dancer $30.32 6/13/2017 31 GelFast $25.80 3/29/2017 9 Gonzalez, Danny 2 Gonzalez, Danny 64 Anderson, Robin 4 Rodgers, Bob Quad Quad Sunbell Majestic Beaut Quad 32 Phenolic Sunshine $31.24 4/2/2016 33 Icarus MTA $37.36 3/9/2016 34 2/3/2017 35 Units Price Per Unit Discount 9/25/2017 36 0 $0.00 7/4/2016 37 10 $0.02 12/5/2017 10 Bryan, Viola 38 15 $0.10 6/21/2016 39 25 $0.35 7/3/2017 40 44 $0.45 9/24/2016 41 75 $0.50 1/9/2016 42 100 $0.55 2/23/2017 10 Nichols, Claudia 37 Gonzalez, Danny 58 Bryan, Viola 8 Richardson, Kristina Quad 5 Gonzalez, Danny Quad 3 Gonzalez, Danny 56 Gonzalez, Danny 1 Nguyen, Sheldon 51 Gonzalez, Danny 37 Miles, Josefina Carlota Doublers Sunbell Carlota Quad Bellen Wind Dance Quad Sunbell Sunbell Quad 43 8/20/2016 5 Anderson, Robin Quad 44 5/16/2016 1 Gonzalez, Danny Quad 10/2/2016 4 Richardson, Kristin Sunset
Expert Answer:
Posted Date:
May 19, 2024 01:16 AM
See More Questions
Suriname Taxation Laws And Regulations Handbook Volume 1 1st Edition - ISBN: 1433081059 - Free Book
Study smarter with the SolutionInn App
Download on the App Store
Continue with the mobile website