Adding multiple values to one key of Dictionary in excel

[saneeth_kandukuri]

Hi ,
Can anyone help me about how to add multiple values to one key in excel .

value : 1.per
2.Pbo
3.par
key : perth
The above 3 values should be added to only one key value and if i get Pbo then, the key value should get perth and another two values also. Can anyone suggest me in excel .

[shalinisettu (jessy)]

hi @saneeth_kandukuri
refer @Uemoe 's logic ,

Dictionary with 2 Values

In your case better option use Dictionary(Of String, Tuple(Of String, String)). dict = New Dictionary(Of String, Tuple(Of String, String)() From { {“key1”, Tuple.Create(“Value1”, “Value2”)}, {“key2”, Tuple.Create(“Value3”, “Value4”)} } to get value back: dict(“key1”).Item1 - return “Value1”, dict(“key1”).Item2 return “Value2”

it might be aid u…