In cell C11, Create a nested if statement to look up the Sales Rep for each region that is found in cells L1:M5. Copy and paste the formula down through the rest of the database.

Whitman Sorvine Nested Units Unit Cast Total Cost Total Sale 7/12/15 East 7/29/15 East 8/15/15 East 9/1/15 Central 2 125.00 East Pen Sale: 10/5/15 Central 2/12/15 Central 15/16 Central 410/16 Central 4/27/16 East Sorvino Penci 6/17/16 Central 5 125.00 12.49 87/16 Central 3 275.00 Sarvino Pencil 27/16 We 19.99 12/21/16 Central