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

[RobFJ]

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

 

[RobFJ]

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

 

[Bernie Deitrick]

In C15, use

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

HTH,
Bernie
MS Excel MVP

 

[Dave Peterson]

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

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