Scripting Dictionary help

Sorry Will!
I do not have Experience using collection. I do not know why do you need to use 4 keys, unless you wish to compare data in 4 columns. So far, I am only familar with 2 keys. What some people call them a parent and child. You can use the parent and child to test if an item exists and if so to do someting about it. If it is a parent , you are testing 1 column ony, but if you have a parent and child, you have two columns to test.

For e.g, in your case, if you wish you want to test if a value exists in a cell ,then I want to do something about it (e.g, add it in your case). Remember, keys and items are pairs, so you can not use the same keys twice,,hence the reason for using the exists method to test if the key has already be used(assigned), it does, VBA overwrites the existing key.

You can use collection, instead of dictionary, but my understanding is that you can not retrive items(values) with unique keys.
It looks like your setting is right. You are adding values (items) in to your dictionary, but you eventually need to retirve your items(values) and keys.