Search for more cells in a different sheet and copy another info in the current worksheet

Hello,

First of all, thank you for your help.
I tried to find some codes for my problem, but i didn´t found the right one and i wasn´t able to change them.

I have 500 numbers in an document. It is called ''Idea'' and the sheet is calld TUL.
The numbers are in colume F.
The macro should search in another document(Tosearch) with also 500 numbers on one sheet (Current Week), if it´s on this list. In this document the number is in column G.
If the number is on it, the macro should copy column Z from the same row in the document with the searched numbers in column P.

I have some macro, but it was only working for one searched word, but not for different words.
Can you please help me with this problem.

Thank you very much.

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you