? 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.
|