Generating information from drop down lists and other fields

Hi all,

Ok so the title doesn't explain this very well.
I am creating an excel document, in this document i have a drop down list. On sheet 2 of this document i have the drop down list fields, however next to it i have further information which i want to be used around the document.

The idea is when i select one of the fields on the drop down list on sheet one, another cell on sheet one will automatically enter the information i have pre-written on sheet 2 next to the drop down field i have selected (really sorry if this doesn't make any sense) (just for clarification the pre-written information will change for the different field selected on the drop down list).

Thanks for your help

Warren

Can you post a small sample file showing what you expect the results to be.

To post a file click "Go advanced" then paper clip icon. (then Browse, Upload, Done)

So heres a basic version of the document, sheet one shows the data i want everyone to view, what i need to do is when i select the shape from the drop down list the other details must automatically populate.

Hope this helps

Based on sample put this in C5 and copy down

=INDEX(Sheet2!$C$4:$F$6,MATCH($C$4,Sheet2!$B$4:$B$6,0),ROW()-4)

thank you so much!!
It works on the example is their a website where i could find out how to do this in easy steps because the above: =INDEX(Sheet2!$C$4:$F$6,MATCH($C$4,Sheet2!$B$4:$B$6,0),ROW()-4) goes straight over my head

Post a file in the format of your real data and I'll add the formula.

Look here for an explanation of INDEX/MATCH.....

https://support.microsoft.com/en-us/kb/59482

See the attached for explanation of the formula used in your example: hope this helps.

Change the drop-down list to see how the parameters change.