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