What is the best way to lookup a value in a listboject?
For example :
How do I get a phone number of customer 12?
I would normally use an array:
Look up in which position the number 12 is and then use the cell offset to retrieve the phone number.
However, as this code is implemented in a userform which has a number of array lookups, I have the impression that this method slows down the opening of userform.
Is there any other way which you suggest I should use?
I have attached a sample file.