Ask Your Question
0

Putting a string formula into a Calc cell

asked 2017-06-18 09:03:31 +0200

Dòmhnall gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-18 15:25:13 +0200

Lupp gravatar image

updated 2017-06-18 15:28:29 +0200

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":)
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".

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-18 09:03:31 +0200

Seen: 25 times

Last updated: Jun 18