Can a dictionary key hold more than one item?

[dwx]

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.

[jindon]

Use array in item.

[dwx]

thanks. how does that work though?

[jindon]

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.

[dwx]

22.xlsm here, thank you.

Name will be the unique ID.

[jindon]

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.