Auto Populate cells based on Drop-down selection

[stepzuko]

Hello,

I am trying to auto populate columns with a percentage value based on a drop down box selection in the adjacent cell. For example, when a user selects "Procurement", "Won", "Quote" etc. in the Status column, I would like the Confidence column to automatically populate with it's corresponding percentage, 10%, 50%, etc. and I would like to have this set to automatically happen when the Status column option is populated for all remaining cells in the confidence column... Is this possible using formulas? Or would it need to be done with VB? I have searched other posts and tried suggestions but non of those solutions are working for me. I have attached a copy of the file I am working with. ANY help or point in the right direction would be greatly appreciated, I am totally stuck.

[gak67]

Try either of these in F2 and copied down:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[azumi]

=IFERROR(VLOOKUP(A1,Draft!$E$2:$F$20,2,FALSE),"")

[alansidman]

In F2, type =VLOOKUP(E2,Definitions!$A$1:$B$6,2,FALSE) and copy down.

[stepzuko]

gak67,

Thank you so much -if you have a moment, I am curious to understand just how the above statement(s) actually works?

[alansidman]

Look at these two links:

http://www.techonthenet.com/excel/formulas/vlookup.php

http://www.contextures.com/xlFunctio...tml#IndexMatch