IF function and Vlookup.. I have done it but its giving me an error msg, please just help me fix this error.

1.In cell M4, enter a formula that uses an IF function and structured references to assign a value rating to each customer. (Hint: You will need to use an AND function in this formula.)

The IF function should check if a customer has a Tenure field value greater than 3 years AND 2016 Purchases greater than $250.

If the customer meets both those criteria, the function should return the value High.

If the customer does not meet both those criteria, the function should return the value Low. If necessary, copy the formula you created in cell M4 to the range M5:M27.

2.In cell P7, enter a formula using the VLOOKUP function to look up the Customer ID value shown in cell P4 in the Customers table (located in the range A3:M27). The VLOOKUP function should then retrieve the Discount Amount from the Customers table (the 12^th column in the table) for this record. The VLOOKUP function should find an exact match to the value in P4.

Thank you