Putting a string formula into a Calc cell

I am trying to put a formula into a cell on a sheet so that if I type in a specific textstring (like OUM) into that cell I will be taken to a specific call on another sheet. But I can’t get it right - keep getting Error or Value.
Dòmhnall

Quoting from the question.

…formula into a cell on a sheet so that if I type in a specific textstring (like OUM) into that cell I will be taken to a specific call …

(Supposing “specific call” is a typo and should be read as “specific cell”:slight_smile:
You cannot have a formula in a cell acting on something you type into the same cell at another time.
You may type your “OUM” (e.g.) into C5 (e.g.), and use D5 (e.g.) to create a link to go to a specific cell based on a lookup using the content of C5. This can be done with a combination of the functions HYPERLINK and VLOOKUP, e.g. if a lookup table can provide an assignment of the target address to the key “OUM”.