VBA Looking up Values in Listobjects

  • Hi

    What is the best way to lookup a value in a listboject?

    For example :
    How do I get a phone number of customer 12?

    Table Customers

    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.