Need assistance with this problem

Chegg Home Study tools My courses My books Career Life Find solutions for your homework Search home / study / business / accounting / accounting questions and answers / which function should i used in excel to solve this question? use a function... Question: Which function should i used in excel to solve this question? Us... Which function should i used in excel to solve this question? Use a function to populate the name of the sales rep associated with each sale. D E Sales Rep B Sale Date Customer No. Customer Name 2 01/02/21 43966 Fox Ava Inc 3 01/05/21 43977 Bambi Sandy Co + 01/11/21 43961 Fun Size Tucker Co 5 01/14/21 43954 Diesel Olive Corp 5 01/14/21 43977 Bambi Sandy Co 7 01/15/21 43978 Cheeto Milo Co 3 01/17/21 43961 Fun Size Tucker Co 01/17/21 43977 Bambi Sandy Co 0 01/18/21 43959 Romeo Honey Corp 1 01/19/21 43977 Bambi Sandy Co 2 01/19/21 43966 Fox Ava Inc Amount $ 349,062.00 $ 83,248.00 $ 114,770.00 $ 121,819.00 $ 444,933.00 $ 34,051.00 $ 415,204.00 $ 454,913.00 $ 24,162.00 $ 401,950.00 $ 88.948.00 The sale rep is in different sheet. Show transcribed image text View comments (1) Expert Answer Chegg Home Study tools My courses My books Career Life Find solutions for your homework Search home / study / business / accounting / accounting questions and answers / which function should i used in excel to solve this question? use a function... Question: Which function should i used in excel to solve this question? Us... Which function should i used in excel to solve this question? Use a function to populate the name of the sales rep associated with each sale. D E Sales Rep B Sale Date Customer No. Customer Name 2 01/02/21 43966 Fox Ava Inc 3 01/05/21 43977 Bambi Sandy Co + 01/11/21 43961 Fun Size Tucker Co 5 01/14/21 43954 Diesel Olive Corp 5 01/14/21 43977 Bambi Sandy Co 7 01/15/21 43978 Cheeto Milo Co 3 01/17/21 43961 Fun Size Tucker Co 01/17/21 43977 Bambi Sandy Co 0 01/18/21 43959 Romeo Honey Corp 1 01/19/21 43977 Bambi Sandy Co 2 01/19/21 43966 Fox Ava Inc Amount $ 349,062.00 $ 83,248.00 $ 114,770.00 $ 121,819.00 $ 444,933.00 $ 34,051.00 $ 415,204.00 $ 454,913.00 $ 24,162.00 $ 401,950.00 $ 88.948.00 The sale rep is in different sheet. Show transcribed image text View comments (1) Expert