Show range of cells with dropdown list

[Protheus]

Hi all I need some help in the following.

I have two sheets, Ax and Bx;

In sheet Ax I created a dropdownlist menu with values:
- Value 1
- Value 2
- Value 3

In sheet Bx I have 6 rows of cells with data lets say:
A1 --> A5
B1 --> B5
C1 --> C5

E1 --> E5
F1 --> F5
G1 --> G5

Now what I want to do is that if I select Value 1 from the list in sheet Ax it will grab range from sheet Bx: A1 --> A5 + E1 --> E5 and show me those.

If I selct Value 2: It will grab range from sheet Bx: B1 --> B5 + F1 --> F5 and show me those.

Same with Value 3.

How can I do this ?

 

[Protheus]

SOrry - this is all done in Excel 2007.

 

[SkipVought]

Hi,

Show you these WHERE?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Protheus]

sorry - I want to display the info in sheet ax - let say next to the dropdown menu

 

[GlennUK]

So, you want 5 cells from column A and 5 cells from column E when Value 1 is chosen.

It seems like a simple indexing thing to me ( but maybe I haven't grasped everything you want ), where you'd have formulae like this in your first return column:

=INDEX(Bx!$A$1:$C$5,1,MATCH(Ax!drop_down_selection,{"Value 1","Value 2","Value 3"},0))

where the ,1, would be replaced by 2, 3, 4, 5 for the rest of the formula for the rest of the rows. Am I going in the right direction?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Protheus]

gonna try it out - tnx for the replay