Good Morning,

I'm a newbie at this particular forum and would like to know if my question is even possible.

I have a list of options for my end-user to chose from. One of the options I would like to be dynamic. In other words, if they chose option 5, they must enter in the parameters for that option.

List :
A
B
C
D
F
In A1 I have my list, in B1 I have a price returned.
Enter in A, B, C, D - my vlookup picks it up and returns a price. (I also have a few if statements in there to validate it against other cells)
Enter in F and a pop-up or something maybe pops up and asks the user for price 1 and price 2.

I want to protect my vlookup so my users cannot overwrite the returned price.

Is this even possible? I have no problem teaching myself some code if that's the case.

Thanks!