Hello,

I am new to this forum and have been looking at past threads to see if my issue can be resolved but with no luck.

I am trying to allow the user to input a value if a specific cell says "INSERT WALL" but if it does not, then there is an index to another worksheet that displays the value.

It seems like there is a way to do this through VBA, but I am unfamiliar with VBA, so some help would be great. Here is the basic set up:

Cell D3 is a drop down list that says "INPUT WALL" or other various things.
IF D3 = "INPUT WALL" I want the user to be able to input a value into cell E3
else, I want E3 to be indexed from another worksheet with matching, (which I know how to do)

Thanks!