VBA index&mach through loop

Hello,

I incorporated index&match functions through vba.

But I have some error when I put it in the for loop. Also I want for BOOKMARK10 to use that string (where is called index&match function) and to put it in Word.

Please find an attachment .xls below. Some of the file is written on Cyrillic letter, and some on Latin.

What does program do: As you can see in B2 "Adam" is entering parameter for lookup from sheet3 (where are all the names).
In cell Q2 is the function of lookup "Adamu".
So firstly I wanted to pull from Q2 in MS WORD through BOOKMARK10, but eventually an idea have crossed on my mind, why the heck I am creating separete column with lookup vaues when I can hard-code it through vba.

Here is the (also, you can view the code by downloading the .xls)

Please Login or Register  to view this content.

Thank you very much!