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