Changing the value in a cell (but a bit more complex than that <G)
 

I've got a list of fixed numeric values in cells B12 to B30.

I want to be able to put an asterisk in any one of cells A12 to A30 (only
ever one) - say A15. and for the corresponding value in the B column (ie
contents of B15) to be shown in another cell - say C15

Can SKS help out.

TIA

Rob

Changing the value in a cell (but a bit more complex than that <G)
 

Just seen my original post where it is a bit ambiguous

Cell C15 would always contain the result independent of whether the asterisk
was in row 2 or row 20

Hope this clarifies things

Rob

"RobFJ" wrote in message
...
I've got a list of fixed numeric values in cells B12 to B30.

I want to be able to put an asterisk in any one of cells A12 to A30 (only
ever one) - say A15. and for the corresponding value in the B column (ie
contents of B15) to be shown in another cell - say C15

Can SKS help out.

TIA

Rob

Changing the value in a cell (but a bit more complex than that <G)
 

In C15, use

=INDEX(B12:B30,MATCH("~*",A12:A30,FALSE))

HTH,
Bernie
MS Excel MVP


"RobFJ" wrote in message
...
I've got a list of fixed numeric values in cells B12 to B30.

I want to be able to put an asterisk in any one of cells A12 to A30 (only ever one) - say A15. and
for the corresponding value in the B column (ie contents of B15) to be shown in another cell - say
C15

Can SKS help out.

TIA

Rob

Changing the value in a cell (but a bit more complex than that <G)
 

=index(b12:b30,match("~*",a12:a30,0))

The ~ means that I want to use the asterisk as a real asterisk--not as a
wildcard.



RobFJ wrote:

I've got a list of fixed numeric values in cells B12 to B30.

I want to be able to put an asterisk in any one of cells A12 to A30 (only
ever one) - say A15. and for the corresponding value in the B column (ie
contents of B15) to be shown in another cell - say C15

Can SKS help out.

TIA

Rob

--

Dave Peterson