Linking drop down box to information

[MarcSwift]

Hi Guys.

I have two sheets with exactly the same column names on it.

One sheet is called "master" and the other sheet is called "mainpage".

I have entered all the information i need into "master" under the correct columns and headng.

In sheet "mainpage" i have created a drop down which links to the first column on "master". When i select a name from that drop down box, i want all the other information i have entered into "master" to appear alongside the drop down list.

For example, from the drop down list i select "Michael" and then all the information from the "master" sheet shows up in the "mainpage" sheet that relates to Michael.

How do i go about doing that?

Hope you understand.

Thanks!!

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[MarcSwift]

Fantastic thank you!