Hello all...
here is my situation:
On Sheet2 of my workbook I have a set of data that starts at B3:B9. Next to
column "B" I have column "C-F" with data that corresponds to each row of "B".
For example:

B2=Stock C-F2=price,PE, etc...

I have highlighted the stocks listed in column "B" and defined a name for
them.

On Sheet1 I have gone through the validation and set up the pull down menu
where I can select the stock from Sheet2.

But my question is how can I set it up so that when I choose the a stock
from the pull down list in the adjacent columns it returns the values from
columns C-F?

I know this is a round about way to ask a question, I just want to provide
as much information as possible.

Thank you all so much,
Confused Man