I have a data validation drop down list and I was wondering if I could
create a If Function that can create more than just a simple true false
response.

For example if I select "Sold Wholesale" in the status list I created it
will input the defined wholesale price, but If I select "Sold Retail" It will
enter the defined retail price, yet again If I select "Available" it will
enter "N/A"

Thank you.