I have a table where users are inputting data. They are required to select an action type in a drop down. Another cell assigns a value based on what they select on the dropdown. What I am looking to do is request user input if they select a specific dropdown. For example: Drop Down Values =IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),"") If the user selects A,B,C or D in the dropdown, I want the vlookup to find the value on sheet2. However, if E is selected I want the user to provide that value via an input box. I do not want the user to simply type the value into the cell because this is in a table and I want all the formulas to be preserved Thoughts?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

If dropdown equals specific text then prompt for input, otherwise do a vlookup

Thread starter horrellbt01
Start date Feb 14, 2022

horrellbt01

Board Regular

Feb 14, 2022

I have a table where users are inputting data. They are required to select an action type in a drop down. Another cell assigns a value based on what they select on the dropdown.

What I am looking to do is request user input if they select a specific dropdown.

For example:

Drop Down	Values
	=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),"")

If the user selects A,B,C or D in the dropdown, I want the vlookup to find the value on sheet2.
However, if E is selected I want the user to provide that value via an input box.
I do not want the user to simply type the value into the cell because this is in a table and I want all the formulas to be preserved

Thoughts?