Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |