Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel 2013 Workbook that has a worksheet (sheet 1) that contains two columns (one column for number and the second column for description, they are separate columns, but 1:1).

On the other worksheet, when a user enters a number from the drop-down list (pulling from the number column in sheet 1), I would like the description column next to it to auto-populate based on the data in the description column from sheet 1, and vice-versa.

Does this require VBA? If so, how can I start doing this?

share|improve this question
up vote 0 down vote accepted

I would use a VLOOKUP function in the description column. I would convert both sheets to Tables (Insert ribbon) to automate copying down the formula as new rows are added.

share|improve this answer

Have you tried the "form" function for those cells? You may have to customize your ribbon to add the "form" function.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.