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?


    [ATTACH=CONFIG]69437[/ATTACH]
    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.


    Thanks


    Maria