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.

The sale rep is in different sheet.

E Sales Rep A 1 Sale Date 2 01/02/21 3 01/05/21 7 01/11/21 5 01/14/21 5 01/14/21 01/15/21 3 01/17/21 2 01/17/21 0 01/18/21 1 01/19/21 2 01/19/21 B Customer No. Customer Name 43966 Fox Ava Inc 43977 Bambi Sandy Co 43961 Fun Size Tucker Co 43954 Diesel Olive Corp 43977 Bambi Sandy Co 43978 Cheeto Milo Co 43961 Fun Size Tucker Co 43977 Bambi Sandy Co 43959 Romeo Honey Corp 43977 Bambi Sandy Co 43966 Fox Ava Ins D 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