=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