Ask Your Question

Revision history [back]

Function for Calc

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