Excel 2010 Dropdown

[Dolby]

Hi,

If I have 3 simple lines I'd like to enter (partner tier, description, discount):

Bronze ; Bronze Certified ; 10%
Silver ; Silver Certified ; 20%
Gold ; Gold Certified ; 30%

I'd like to have a drop down box for their tier, and it automatically pulls description and discount based on tier. I can do the dropdown - but how do I get it to auto populate?

 

[AlmightyBender]

Best is to put the above data into a table and then do a vlookup:

If dropdown is in A1 and you want automated data in B1 and C1 then
B1 =Vlookup(A1,table,2,False)
C1 =Vlookup(A1,table,3,False)

 

[Dolby]

Thank you... Will read up a little more vlookup too!