Script Dictionary Not Matching

Good Day,

I'm learning (experimenting) with the Script Dictionary, but I'm unable to use the Exists Method (probably the way I want it to work). I'm using the script dictionary like a lookup, but script dictionary is not giving me unique items, and it is not indicating the items exist in the dictionary.

Sheet1 collects the items for the script dictionary, and Sheet2 should give me the result after running the macro.

I've uploaded a file with the test data.

I'd appreciate your help assisting me in understanding this area of VBA.

Thanks,
Xrull

Not sure what it is you're trying to do but maybe:

Please Login or Register  to view this content.

Regards

TM Shucks,
I'm try to use the script dictionary to match each name on Sheet2 with a Information from Sheet1, and place it in column B of Sheet2. I'm trying to use the script dictionary instead of a vlookup.
I'll be tinkering with your code (save me from myself!).
I've tried this, but it doesn't work

Please Login or Register  to view this content.

Thanks,
Xrull