A B C D E F G H Region Midwest Question 4: Use VLOOKUP to find...

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