Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Evening all

    A schoolboy question, I must be braindead tonight

    Control Toolbox Combo linked to G10 displaying a list from D35237 I want to display information in a seperate cell from E35:E237

    Formula = =VLOOKUP($D$35:$E$237,G10,2,FALSE)

    Answers by carrier pigeon please
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You have the first two arguments reversed

    =VLOOKUP(G10,$D$35:$E$237,2,FALSE)

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks MBarron

    Although I have changed the fields a little and by applying your example I still get #N/A

    =VLOOKUP(G10,$B$102:$C$186,2,FALSE

    Any other thoughts?

    TIA
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Have you linked the combo box to the G10 cell? Enter the formula = G10 in a cell. If your result is not the same as what the combo box is displaying, then you can tell the combo box and the cell are not linked.

Posting Permissions

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