Help!

W

Wolfwillows

Was wondering if there was a way to and if anybody knew how to do the
following:

I have a pick from list in Cell A2 and when Cell A2 has the data fromA3
then cell B2 needs to have the data in B3 and so forth for about 10
cells of data. I hope this makes sense.
I am really hoping someone can help me out with this PLEASE PLEASE :)
 
R

random1970

I'm not quite sure what you mean by a "pick from list" in A2.

Assuming that your pick from list is something like a choose function,
it's not too hard.

In cell A1, type the formula =RANDBETWEEN(1,5), assuming there are five
items in your list. (For this you'll need to enable the Analysis
Toolpak. Go to Tools, Add-ins, and check the Analysis Toolpak, and
Analysis Tollpak VBA options.). Alternately use the formula
=ROUNDUP(RAND()*5,0)

In cell A2, type the formula =CHOOSE($A$1,A3,A4,A5,A6,A7). This will
use the value in A1 to choose an item from your list, which is typed
into cells A3:A7.
Type other lists in B3:B7, C3:C7, D3:D7 etc.
Select cell A2 (the choose function) and fill across above your lists.
Each copied formula will use $A$1, an absolute reference, to choose, but
will choose from the list in their column.

So, if A1 is 1, A2 will have the value in A3, B2 will have the value in
B3 etc.
If A1 is 2, A2 will have the value in A4, B2 will have the value in B4
etc.

Hope this helps.
 
R

random1970

I'm not quite sure what you mean by a "pick from list" in A2.

Assuming that your pick from list is something like a choose function,
it's not too hard.

In cell A1, type the formula =RANDBETWEEN(1,5), assuming there are five
items in your list. (For this you'll need to enable the Analysis
Toolpak. Go to Tools, Add-ins, and check the Analysis Toolpak, and
Analysis Tollpak VBA options.). Alternately use the formula
=ROUNDUP(RAND()*5,0)

In cell A2, type the formula =CHOOSE($A$1,A3,A4,A5,A6,A7). This will
use the value in A1 to choose an item from your list, which is typed
into cells A3:A7.
Type other lists in B3:B7, C3:C7, D3:D7 etc.
Select cell A2 (the choose function) and fill across above your lists.
Each copied formula will use $A$1, an absolute reference, to choose, but
will choose from the list in their column.

So, if A1 is 1, A2 will have the value in A3, B2 will have the value in
B3 etc.
If A1 is 2, A2 will have the value in A4, B2 will have the value in B4
etc.

Hope this helps.
 
Top