For this exercise, use data validation to:

$-$Use "custom validation" $($formula$)$ to accept only Y or N in the Preferred Customer input area Include an input message and an error message. This should be a full stop, not a warning.

$-$create a dropdown list in the Product Code that allows only values from the Project Lookup table

If the customer is a preferred customer, then quote the Preferred Price from the Product Lookup Table $($name this range$),$ otherwise, quote the regular price

If either the Product Code or the Preferred Cuslomer indicator is biank, the Price to Quote should also appear to be blank. You might want to try some functions from the first sheet