Look for text and calculate

[soli004]

Hello!

I have 2 columns (A and B) of text, A and B that needs to be turned into numbers in column C. The text in column A can also occur in column B and vice verse. There can also be 2 or 3 values in column B, there is no "," to separate the values only spaces. Every text name has a value (they are explained in the file but not included in original files). If there is text in both columns it has to add the value for each text. I need to get column C calculated by using VBA. Column C is empty from the start and the rows can be +500.

In the file the result is applied manually.

Thanks

[ARGK]

Hi
If you store a unique list of values, say in a separate worksheet, you can use COUNTIF.
Hope this helps.
Good luck
Tony

[AlKey]

Deleted post