Make only one loop and change compare string

[yiannis1925]

Hello,

I need some help please... Attached find a small example of my code...
Run them with the order
first
second
third

you see that I compare if From Sheet the element of Range A is in Sheet1 in Range A then I copy some columns...
I need to correct two things...

1. Don't want to do 3 loops for it... how can I make just one and copy all values to the correct columns ?
2. When comparing I want to add "_" in front of the values of the Sheet2. So for example... I will not look for "Something_AA_A" but for "_Something_AA_A"

I think this should be easy for you Guru guys

Thank you in advance...