Find word and assign it to another table

Hi guys,

the following:

I have one workbook with 3 Sheets (Table1/Table2/Table3). In Table 3 are the following columns "Table1" and "Table2". I need one script which search in table1 and table2 the words from test1 to test15 and write the assign numbers in table 3 in the right columns / row! If one value is not found, this value should have the number 0 in table 3.

I have the following examples attached, file Mappe1_Test1.xlsx is the before status and Mappe1_Test.xlsx should be the after status.

Can you help me out?

thx

Great, an quick solution I will test this in my sheet now. Is it possible to show the "0" for value which are not assigned (values which are not found in table1/2)?

And can I use this solution, if Table1/2 are not sorted. In my example u will see Test1 - Test15, what about the following construction:

Test4
Test2
Test8
Test7
Test3
Test1
etc.

And if (maybe) Test3/Test5 are not shown? Because I would create one chart of table3 and the x-axis should show test1-test15 and and now every number should assign to the right x-axis value, u know?