Drop Down List

F

Fution

Hi
I am trying to create a drop list from Column A. When i select something
from that list I want it to return the entire row the cell is linked to. For
example:

Cell A1 contains the number 1, Cell A2 the number 2, Cell A3 the number 3
and Cell A4 the number 4. If i select number 2 from the drop down list (Cell
A2) I want it to return the valuse in Cell B2, B3, and B4 in the adjacent
cells.

Thanks And Regards
 
F

Fution

Fution said:
Hi
I am trying to create a drop list from Column A. When i select something
from that list I want it to return the entire row the cell is linked to. For
example:

Cell A1 contains the number 1, Cell A2 the number 2, Cell A3 the number 3
and Cell A4 the number 4. If i select number 2 from the drop down list (Cell
A2) I want it to return the valuse in Cell B2, C3, and D4 in the adjacent
cells.

Thanks And Regards
 
F

Fution

Ok lets try this again, Sorry its late..

Hi
I am trying to create a drop list from Column A. When i select something
from that list I want it to return the entire row the cell is linked to. For
example:

Cell A1 contains the number 1, Cell A2 the number 2, Cell A3 the number 3
and Cell A4 the number 4. If i select number 2 from the drop down list (Cell
A2) I want it to return the valuse in Cell B2, C2, and D2 in the adjacent
cells.

Thanks And Regards
 
G

Gord Dibben

Your description doesn't make much sense.............at least to me<g>

In which cell is your dropdown list?

Where do you want the values from B2, C2 and D2 to appear?

You could use the VLOOKUP function to return looked up values from a table.

Have a look at help on VLOOKUP.


Gord Dibben MS Excel MVP
 
F

Fution

Ok let me try to explain a bit better.

On Sheet 1 would be the sheet containg all the data.
The data on sheet1 is as follows:

A B C D E F
1 1 4 5 6 7 8
2 2 9 10 11 12 13
3 3 14 15 16 17 18
4 4 19 20 21 22 23

On Sheet2 Cell A1 I create a Drop Down List containing the data in Sheet1
Column A.

When I select 2 (Data in Sheet1 Cell A2) from the the drop down list I want
it to also return the data in the same row. Example:

Sheet 2:

A B C D E F
1 2 9 10 11 12 13
2
3
4

Hope this helps.

Regards,
 
G

Gord Dibben

On Sheet1 define the range of A1:F4 as a table named MyTable.

On Sheet2 in A1 create the DV dropdown list by typing 1.2.3.4 in the Source
dialog. Note the commas.

In Sheet1 Select B1 enter =VLOOKUP($A$1,MyTable,Column(),False)

Copy across to F1

Pick number 2 from the dropdown list to get your results in B1:F1


Gord
 
F

Fution

Hi Gord

Thanks a mil, Works perfectly. The VLOOKUP has to be on Sheet2 then it works.
Thanks again.

Regards
Fution

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top