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