Excel Rule/Formula
 

In a Worbook if you have an item in cell A1 and have all the items in the "A"
column available as a drop-down box on another sheet can you create a rule to
say anytime the contents from cell A1 on sheet one is selected in another
sheet then the contents from cell B2 on sheet 1 will automaticlly be placed
in the cell to the right of it?

Example Example
Sheet 1 Sheet 2

Cell A1=Cat B2=Dog Cell A1 from Drop down is Monkey B2 would = lion
Cell A2=Mouse B2= Bird
Cell A3 = Monkey B2= Lion

All contents from Sheet 1 in column A would be available as a drop-down box
in the other sheets. If anywhere in other sheets A1 is chosen then whatever
is in the immediate cell to the right of it in sheet 1 would follow it in the
new sheet?

Sorry if I am not making sense. Any help is greatly appreciated!

Into cell (p.e. B1) next to dropdown (A1) enter the formula like this:
=VLOOKUP(A1,'Sheet 1'!$A$1:$B$100,2,0)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"shobrien" wrote in message
...
In a Worbook if you have an item in cell A1 and have all the items in the
"A"
column available as a drop-down box on another sheet can you create a rule
to
say anytime the contents from cell A1 on sheet one is selected in another
sheet then the contents from cell B2 on sheet 1 will automaticlly be
placed
in the cell to the right of it?

Example Example
Sheet 1 Sheet 2

Cell A1=Cat B2=Dog Cell A1 from Drop down is Monkey B2 would = lion
Cell A2=Mouse B2= Bird
Cell A3 = Monkey B2= Lion

All contents from Sheet 1 in column A would be available as a drop-down
box
in the other sheets. If anywhere in other sheets A1 is chosen then
whatever
is in the immediate cell to the right of it in sheet 1 would follow it in
the
new sheet?

Sorry if I am not making sense. Any help is greatly appreciated!