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