Results 1 to 5 of 5

Thread: Vlookup

  1. #1
    Star Lounger
    Join Date
    May 2005
    Location
    west drayton, Middlesex, United Kingdom
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good morning

    I have a combo box from which I select a name from a range, 'Destination' in the adjacent column to the range C9:C93 is supplementary information that I wish to display when a 'Destination' is selected. I have tried =IF(C2="","",VLOOKUP(C9:C93,2,FALSE)) but I get a value error.

    Am I using the wrong type of look up and/or is the formula completely wrong for the task?

    TIA

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If this is your entire formula, then you are missing the vllokup value.
    =IF(C2="","",VLOOKUP(C9:C93,2,FALSE))

    try this instead

    =IF(C2="","",VLOOKUP(C2,C9:C93,2,FALSE))

  3. #3
    Star Lounger
    Join Date
    May 2005
    Location
    west drayton, Middlesex, United Kingdom
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Danny Williams' post='792629' date='09-Sep-2009 03:58']Good morning

    I have a combo box from which I select a name from a range, 'Destination' in the adjacent column to the range C9:C93 is supplementary information that I wish to display when a 'Destination' is selected. I have tried =IF(C2="","",VLOOKUP(C9:C93,2,FALSE)) but I get a value error.

    Am I using the wrong type of look up and/or is the formula completely wrong for the task?

    TIA[/quote]

    I just tried using INDEX and that doesn't work either =INDEX(C9:C93,$C2) but I get the value error?

  4. #4
    Star Lounger
    Join Date
    May 2005
    Location
    west drayton, Middlesex, United Kingdom
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='mbarron' post='792630' date='09-Sep-2009 04:17']If this is your entire formula, then you are missing the vllokup value.
    =IF(C2="","",VLOOKUP(C9:C93,2,FALSE))

    try this instead

    =IF(C2="","",VLOOKUP(C2,C9:C93,2,FALSE))[/quote]

    Hi M Barron

    Thanks for the response but that is still showing the value error, I have made another column and numbered it 1 - 93 and then in my list range in the combo I have changed it to B9:B93 and then used the INDEX function =INDEX(D993,$D2) and that now works but with a limitation which is that the number now shows with the destination in the combo, for example

    5 Germany

    and when I select it E2 now shows the desired result Berlin, Colgne, Dusseldorf etc. but the Combo is just showing the number 5, ideally I would like itto show just Germany but if it has to show 5 Germany I can livewith it. Any ideas what I need to change in the Combo properties to reflect this?

    TIA

  5. #5
    Star Lounger
    Join Date
    May 2005
    Location
    west drayton, Middlesex, United Kingdom
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Danny Williams' post='792633' date='09-Sep-2009 04:40']Hi M Barron

    Thanks for the response but that is still showing the value error, I have made another column and numbered it 1 - 93 and then in my list range in the combo I have changed it to B9:B93 and then used the INDEX function =INDEX(D993,$D2) and that now works but with a limitation which is that the number now shows with the destination in the combo, for example

    5 Germany

    and when I select it E2 now shows the desired result Berlin, Colgne, Dusseldorf etc. but the Combo is just showing the number 5, ideally I would like itto show just Germany but if it has to show 5 Germany I can livewith it. Any ideas what I need to change in the Combo properties to reflect this?

    TIA[/quote]
    Doh

    Got it 'Column Widths' first 1 set to 0 (hides the number), second set to 2 shows the Country 0,2

    Thanks

Posting Permissions

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