Hello!

I am trying to create a Sales Order form that will allow me to use a Data Validation drop-down list of titles that are attached to different up-charge percentages for various products we sell.

My Data Validation list needs to show titles when the salesperson clicks on the drop down, but the cells in column 'I' need to only show the answer to the formula itself, once the title is selected.

formula.PNG

In other words, I want 'Tile' to show up as my DV list option, and when selected it needs to make the formula =A17/0.65 in I17

Is this achievable in any way? Even if the DV list is located off to the side (similar to my cost line), or I go about this a completely different way, I just need to get to my end goal

Thank you for your help!

-Meg W