Switch Vs Lookup

[A_Learner]

Hi,

I have keyA: value-a1, value-b1, value-c1
KeyB: value -a2, value-b2. Etc

In general key: multiple values.

A bunch of them.

What is the best and fastest way to find
Key based on value?

I am thinking excel and lookup or switch case.

Please advise most efficient way of finding key corresponding to a value from multiple values.

Thanks a lot

[adiijaiin (Aditya Jain)]

Hi @A_Learner ,

It would be faster and efficient with Switch.
Lookup on DataTable won’t be fast.

[ppr (Peter)]

on of many options
LkUp Dictionary with LINQ filter code

[A_Learner]

Thank you.
Does switch allow multiple case values which are string type?

Regards

[A_Learner]

@ppr, Can you please provide me an examole?

Thanks

[adiijaiin (Aditya Jain)]

Yes it will allow multiple string values.

[ppr (Peter)]

how / which datatype had you forseen for the value, string, array, list, , comma seperated string?

[A_Learner]

Key is string.
Values for each key are strings.
I need to find key based on value.

Thank you,

[A_Learner]

Hi,
Can you please provide an example. In switch case multiple string values not working for
Me.

Thanks

[Nitya1 (Nitya Tomar)]

Hi @A_Learner

If you have a collection of keys with multiple values and you need to find a key based on a given value, using a dictionary or a data structure that supports reverse lookup would be the most efficient approach.

Thanks!!

[A_Learner]

Thank you @Nitya1 @ppr @adiijaiin