Can a dictionary key hold more than one item?

would like to store multiple items onto one key, eg.

Please Login or Register  to view this content.

looking for an alternative to "application.worksheetfunction.vlookup" or "find" + offset to lookup values with an ID.

Use array in item.

thanks. how does that work though?

It depends on how you are loading data in dictionary.

A small sample workbook with data/result showing what you are trying to do would help.

22.xlsm here, thank you.

Name will be the unique ID.

I would store whole data in an array and loop, but used range instead for a descriptive example.

You can get out of the msgbox loop by Ctrl + Break.

Please Login or Register  to view this content.