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

  • Thread starter Thread starter RobFJ
  • Start date Start date
R

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
 
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
 
=index(b12:b30,match("~*",a12:a30,0))

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