Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Vlookup with ComboBox (2003)

    I am attaching my workbook so you can take a look and tell me what I'm doing wrong. I created a list and named it on Sheet 2. This is my look up table.

    On Sheet 1 I created a combo box to pull the first name on Sheet 2. Works great.

    Now, I want other cells to populate with data in the lookup table.

    It appears to work that when I pick someone's name from the drop down list, the corresponding address info populates the appropriate cells in the worksheet... but this only seems to work the first time. If I change my mind and pick someone else's name, the address info doesn't populate correctly.

    What am I doing wrong? Would you mind taking a look and let me know.

    Thank you!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Vlookup with ComboBox (2003)

    Your lookup table is not sorted on column A, and you want exact matches, not approximate ones. Therefore you must add FALSE as 4th argument to all VLOOKUP formulas (FALSE = do not approximate), for example

    =VLOOKUP($A$2,Tables!$A$2:$E$8,2,FALSE)

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vlookup with ComboBox (2003)

    duh.. ok. That makes perfect sense. Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •