Oct 08 2020 03:36 AM
Oct 08 2020 03:57 AM
@Hans Vogelaar 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?
Oct 08 2020 04:39 AM
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.