Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to create a VLOOKUP formula for the Price to Quote using the table array above. Please help I was able to create the
I need to create a VLOOKUP formula for the Price to Quote using the table array above. Please help
I was able to create the IF formual for Preferred Customer where input can only be a Y or N and also the drop down box for Product Code.
However, I am having a hard time getting the correct VLOOKUP formual in D19.
Thank You
For this exercise, use data validation to -Use "custom validation" to accept only Y or N in the Preferred Customer input area. Include an input message and an error message 1create a dropdown list in the Product Code that allows only 2 values from the Project Lookup table Product Lookup Table A0001 A0002 A0003 A0004 A0006 A0007 A0008 A0009 A0010 Preferred Price Regular Price $150.00 $654.00 $5.000.00$5,468.00 $864.00 $578.00 $549.00 $621.00 $869.00 $549.00 $140.00 $600.00 4 If the customer is a preferred customer, then quote the Preferred 5 Price from the Product Lookup Table (name this range), otherwise, 6 quote the regular price $800.00 $525.00 $500.00 $575.00 $825.00 $500.00 If either the Product Code or the Preferred Customer indicator is g blank, the Price to Quote should also appear to be blank 10 11 Protect this worksheet so that a user can change only the input cells 12 (shown in yellow on this page) 13 14 15 Preferred Customer (Y/N) 17 18 19 20 Product Code Price to QuoteStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started