Enter a nested lookup function in cell E4 that uses the cells E2 and E3 to return a specific sales record. For example, using the current data, you want the function to return the third quarter sales for Erica.

File Insert Page Layout Formulas Data Review View Help Tell me what you want to do ut Calibri Wrap Text jN3z74PbXr ECopy Paste % , soga Conditional Format as| IgGB51MeLy Forattig Table Blu ) Merge & Center $ Format Painter Clipboard Font Alignment Number Styles E4 fic Look up Sales rep name Erica Quarter Amount sold Report Dat 2 2/1/2018 Bonus Info Threshold200,000 Domestic 3% 5% 4 International 2018 Sales Total By Quarter Q1 Sales Rep 8 Ron 9Nick 10 Sall Hire Date Years Worke Tota Location 3/1/2016 5/12/2014 3/14/2017 7/20/2017 10/6/2010 11/3/2009 8/4/2010 6/9/2009 4/16/2012 1/7/2009 3/25/2014 8/15/2011 3/15/2013 1.9 $ 29,911 92,249 $ 46,475 33,947 202,582 International $ 10,129.10 3.7 $ 0.9 S 36,991 S 54,102S 63,914 S 42.642S 197,649 Domestic S 0.5 50,087 25,179$ 64,912 68,875 209,053 Domestic 6,271.59 32,752 $ 30,222$ 43,997$ 93,277 200,248 International $ 10,012.40 12 Bob 13 Mark 14 Swathi 15 Mike 16 Rick 52,923 62,673 $ 63,635 57,410 236,641 Domestic ,099.23 59,678 70,934 78,410 $ 32,994$ 242,016 Domestic 7,260.48 66,385 $ 74,27036,165 $ 76,548 253,368 Domestic 7,601.04 8.2 $ 7.5 S 8.6 $66,936$ 72,838 60,479 63,324 $ 263,577 Domestic 7,907.31 5.8 $74,507 94,17841,391 $27,235 237,311 Domestic 7,119.33 9.1$76,88949,266$ 64,225 $ 55,410 245,790 Domestic7,373.70 3.9 $ 6.5 $97,426 43,061 26,122 $ 83,391 250,000 Domestic 7,500.00 4.9$98,094 47,398$ 80,755 40,446 266,693 International 13,334.65 90,515 $ 29,23830,973 $ 32,145 182,871 Domestic $ 18 Rich 19 Daryl 20 Erica 21 23 25 Sales | Database | Addition Ready e here to search