Function for Calc

asked 2019-01-11 09:57:37 +0200

seeker80 gravatar image

Hello,

Is it possible and if so please help me in making the following mechanism.

In the first column I have a symbol containing letters, numbers and special characters.

In the second column I have a symbol containing letters, numbers and special characters. Some of the symbols are identical to those in the first column but there are also others.

The third column has numeric values.

I need a function that will check if the next symbols in the first column are in the second column. If the same value is found, the corresponding value from the third column will be returned.

thanks in advance

Richard

edit retag flag offensive close merge delete

Comments

1

"...will check if the next symbols in the first column are in the second column."
This urgently needs detailed specification. I don't know a thing like "the next symbols" not to speak of an implementable clear meaning of the term. You won't get a function like DOWHATIHAVEINMIND().
Same thing with "the same value" in the given context.
No clarification what should be returned if the conditions not are satisfied.

Trying to answer a question not sufficiently clarified is just wasting time.

Lupp gravatar imageLupp ( 2019-01-11 12:09:35 +0200 )edit