If the list is not too long, use Data Validation to select the text and use
VLOOKUP to find the value corresponding the the selected text.

Is this an acceptable solution?

I believe your requested solution will require a VBA macro to achieve it.


"Graham Allen" wrote:

need to click on a cell with a text entry and somehow hyperlink its answer so
that it appears in another cell as a numeric value, I have the all the
numeric values stored.
eg,

Thames Water
12
(Click Thames Water)
(numeric value appears)

The numeric values can be shown and stored on the same document if this
helps or alternatively they can be filed anywhere.