Autofill based on what's picked in a drop down

[Derek]

Hey,
First, this site rocks!

I know that this has probably been taught before, but I can't find it. I want to set up cells to auto fill based on what is picked in a primary cell.
Example:
let's say I have a drop down based on a table list: (A2:A4)
Catalyst 3750-G
OpenGear
ASA-5520

I want to then have 3 cells Autofill as follows,
B2:B4 - Autofill Volts
C2:C4 - Autofill Watts
D2 through D4 - do equation to get AMPs based on B and C. I can do the math with this one, but I want B and C to autofill based on what's picked from a drop down, pulled from a table.

I am able to do advanced conditional formatting to get drop downs that are dependent on the first drop down choice, but I haven't done "auto fills" based on that yet.

Thanks for the help.

 

[Faseeh]

Hi Derek,

Welcome to the Forums, Can you upload a sample file with some data??

Regards,

 

[Derek]

Hi Derek,

Welcome to the Forums, Can you upload a sample file with some data??

Regards,

I uploaded an example file. I showed it with the drop down, and then I also showed what I would want to autofill, based on what device I picked. The last column can be a simple division equation. And, you will notice that I conditionally formatted the total in AMPs column to turn red if it went greater than 16.

Thanks for your time.

 

[koi]

hi,

i think simple vlookup like =IFERROR(VLOOKUP($C5,Table1,2,0),"") in D5, and =IFERROR(VLOOKUP($C5,Table1,3,0),"") in E5 will do it

 

[Derek]

hi,

i think simple vlookup like =IFERROR(VLOOKUP($C5,Table1,2,0),"") in D5, and =IFERROR(VLOOKUP($C5,Table1,3,0),"") in E5 will do it

Wow. That was fast. And it worked. Thanks so much!