Auto-populate from drop down box

[sponge_designs]

Hey all,

Im trying to auto-populate from a drop-down box. Is this even possible?
Sheet 2 (Electrical Connection Database) holds all the data
Sheet 1 (Electrical Connection Form) is the page that I want to auto-populate

Headings on sheet 2 correspond to sheet 1 (linked in fact)

Sheet1 B14 is where the dropdown box is located.
What I would like happen is when a selection from the drop down box is made, the rest autopopulates from sheet2. Make sense?

File attached 2015_Power Requirements.xlsx

Cheers,
Matt

[protonLeah]

b13:

Please Login or Register  to view this content.

B15:

Please Login or Register  to view this content.

Etc.

[FlameRetired]

See if attached does what you want.

BTW: A44:A45 of your form sheet don't exactly match the database headings. I changed those on the form to match.