Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
? Function to copy based on choice
Hi
I think a function would be able to achieve this but I am unsure where to start Say my data is in Col A ColB 12 13 X 15 Someone chooses either 12, 13 or 15 by placing an "X" in B1,B2(in the above case),or B3. Whever the X is placed I woul like to copy the value to cell C2. Is this possible. Thanks Eddie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
? Function to copy based on choice
On Apr 20, 4:40*pm, webels wrote:
Hi I think a function would be able to achieve this but I am unsure where to start Say my data is in Col A * * ColB 12 13 * * * * * * X 15 Someone chooses either 12, 13 or 15 by placing an "X" in B1,B2(in the above case),or B3. Whever the X is placed I woul like to copy the value to cell C2. Is this possible. Thanks Eddie Have a look in the help index for MATCH and then incorporate into INDEX |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
? Function to copy based on choice
On Apr 21, 12:13*am, Donald Guillett wrote:
On Apr 20, 4:40*pm, webels wrote: Hi I think a function would be able to achieve this but I am unsure where to start Say my data is in Col A * * ColB 12 13 * * * * * * X 15 Someone chooses either 12, 13 or 15 by placing an "X" in B1,B2(in the above case),or B3. Whever the X is placed I woul like to copy the value to cell C2. Is this possible. Thanks Eddie Have a look in the help index for MATCH and then incorporate into INDEX Thanks Don - I used the following and it works perfect. =INDEX($A$1:$A$3,MATCH(C5,$B$1:$b$3,0)) Putting the value “x” in C5 and the formula in d5 I can place an x in B1 or B2 or B3 and match the value. I’m guessing there is no way to allow any character be placed in B1 or B2 or B3 other than x and still return the values (allowing for users who fail to use “x” as instructed)? All the best Eddie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
? Function to copy based on choice
On Apr 22, 4:55*pm, webels wrote:
On Apr 21, 12:13*am, Donald Guillett wrote: On Apr 20, 4:40*pm, webels wrote: Hi I think a function would be able to achieve this but I am unsure where to start Say my data is in Col A * * ColB 12 13 * * * * * * X 15 Someone chooses either 12, 13 or 15 by placing an "X" in B1,B2(in the above case),or B3. Whever the X is placed I woul like to copy the value to cell C2. Is this possible. Thanks Eddie Have a look in the help index for MATCH and then incorporate into INDEX Thanks Don - I used the following and it works perfect. =INDEX($A$1:$A$3,MATCH(C5,$B$1:$b$3,0)) Putting the value “x” in C5 and the formula in d5 I can place an x in B1 or B2 or B3 and match the value. I’m guessing there is no way to allow any character be placed in B1 or B2 or B3 other than x and still return the values (allowing for users who fail to use “x” as instructed)? All the best Eddie Try using data validation on Column B, restricting the input to an "X". If any other text is input, an error message appears. That error message can be customized to explain that an "X" is needed. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
? Function to copy based on choice
Hi Eddie,
Am Fri, 22 Apr 2011 13:55:59 -0700 (PDT) schrieb webels: I?m guessing there is no way to allow any character be placed in B1 or B2 or B3 other than x and still return the values (allowing for users who fail to use ?x? as instructed)? for any character: =INDEX($A$1:$A$3,MATCH("*",$B$1:$B$3,0)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
? Function to copy based on choice
On Apr 24, 2:05*pm, Claus Busch wrote:
Hi Eddie, Am Fri, 22 Apr 2011 13:55:59 -0700 (PDT) schrieb webels: I?m guessing there is no way to allow any character be placed in B1 or B2 or B3 other than x and still return the values (allowing for users who fail to use ?x? as instructed)? for any character: =INDEX($A$1:$A$3,MATCH("*",$B$1:$B$3,0)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 HI Claus Thanks for you suggestion. I slightly changed what you suggested to =INDEX($A$1:$A$3|MATCH("*"|$B$1:$B$3|0)) It kinda worked however it gave me the value in A1 even when no character was inserted. It seems that the "*" also allows for a blank entry. Thanks Eddie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list based on choice of another dropdown | Excel Discussion (Misc queries) | |||
Sorting based on Drop Down choice | Excel Discussion (Misc queries) | |||
Forcing value based on list choice?? | Excel Discussion (Misc queries) | |||
Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
How to sum a column based on the choice of autofilter? | Excel Programming |