Joham Shason via OfficeKB.com
Guest
Re: Royally Confused!!
Hi, I think you can use the lookup formula to do this. The formula in sheet 1
will be =VLOOKUP($A1,Sheet2!$B$3:$F$9,COLUMNS($A$1:B1),FALSE). Hope this
works.
Confused Man wrote:
>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
--
Joham
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200508/1
Bookmarks