Drop down menu help

[joeperry1971]

Hello,

I am trying to populate a set of rows in a column with company address information from a drop down menu. From the drop down, I want to be able to select the company, then automatically populate the address, phone number, etc... in the rest of the column under the company select box. I thought I could do that with a named range from another sheet...but I have been unsuccessful.

I looked through the forum, but I am not sure how to even word the search.
I'm an Excel n00b.

 

[Andrew Poulsom]

It sound like you need to use the VLOOKUP function. Check it out in Excel Help.

 

[joeperry1971]

lost

I've read some stuff on vlookup. No idea how that works.
I have no idea how to make that work with what I am trying to do.