I am trying to create a form in Excel that auto-fills data when a certain selection is chosen from a drop-down list.

I have the table:

Apple | Red
Orange | Orange
Banana | Yellow
Watermelon| Green

I have created a drop down box that has each of the fruits and when I select that fruit I want different cell to fill the color.

I tried using the following formula:


But it did not seem to work (when I selected "Apple" it showed "Yellow" in the cell).

Any suggestions on how can I make this work?

  • You need to force an exact match in VLOOKUP(). Add ",FALSE" (without the quotes) after the 2. Click the link to read about VLOOKUP(). – Bandersnatch Mar 13 '18 at 18:38
  • 1
    That worked! Thank you so much for your help! – J Mallas Mar 13 '18 at 21:08

Try this formula: =VLOOKUP(E1,A:B,2,FALSE)

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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