How to calculate formula with data validation option?

[beaverbg]

Hi, I'm trying to do something of the sort of item x = x price, addition to item y = y price. My question is how to link the two fields so that when the add-on item is selected, the corresponding price of the add-on to the original value is calculated and accordingly if the add-on is not selected, the price of the item will not change. Thanks!

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Richard Buttrey]

Hi and welcome to the forum.

Difficult to say since your post isn't clear and as Pepe says please upload the workbook.

You probably need a VLOOKUP() function in C1 but won't know until you tell us the result you expect.