View the step-by-step solution to:

IF function and Vlookup.

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 12th column in the table) for this record. The VLOOKUP function should find an exact match to the value in P4.

Thank you

Background image of page 1
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question