using keys of the dictionary

Hello everybody!
I come here often but the first time I post a thread, and I don't speak English very well.

I need help for using keys of my dictionary. On this image as example I need to find all different values in the column A (sheet 1) check them in the column A of the sheet 2. Then copy the corresponding value of the column B .offset(0,1) in an other sheet. I have this code now but doesn't work:

Please Login or Register  to view this content.

exemple.jpg

If somebody can help me!?

Try like this

Please Login or Register  to view this content.

Kind regards
Leo

That works exactly as I want! you were very quick!
Now I'll try to understand it!
Thank you very much!!

Hi,

Here is a version I was writing before Leo posted his. His looks more efficient, but I figured I would post mine since the code is a little bit different.

Please Login or Register  to view this content.

Thanks,

Dan

Hi Dan!
Thank you for your help! I'm learning VBA so it's really fine that I can compare both!