Forum Discussion
Combine vlookup and data validation drop list
Can you explain in detail what you want to do? Thanks in advance.
HansVogelaar I am trying to create a request for where you can choose from a dropdown list in column "A" or column "B". When selecting from the dropdown in column "A" it would fill in the information in columns "B" and "C". If you select from the dropdown in column "B" it would fill in the information for columns "A" and "C". is this possible?
You can't combine them, because selecting an item from the validation dropdown will overwrite the VLOOKUP formula. But you can simulate it with VBA code in the Worksheet_Change event procedure of the sheet.
I have attached a sample workbook with a simplistic example. If you select a first name from the validation dropdown in column A, the code will fill in the last name in column B, and vice versa. Column C contains an ordinary VLOOKUP formula.
Please note that the workbook is a macro-enabled workbook and that you have to allow macros when you open it.