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

    1 have a combo box that is linked to D9 and takes its value from column 2 in a range of 3 columns, for example

    Part Number = column 1 (Begins A12)
    Part Description = column 2 (Begins B12)
    Part price = Column 3 (begins C12)

    On a second worksheet I am constructing an order form and need to show the the part description, therefore

    =Parts!D9 shows the partnumber
    =Parts!combobox1 = #NAMEŁ

    Any ideas please how I can get the part number to show?
    Cheers

    Steve

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

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You'd have to do a lookup on a table that holds both the part numbers and the descriptions.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  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 Jan Karel

    This is not something I am familiar with, I have tried a few things based on some Googling and I think it should look something like this

    =Vllookup(PARTS!D9,PARTSLIST,1,FALSE)

    Where:-

    PARTS! is the sheet that contains the range

    D9 is the linked combo box cell (from a control toolbox combo)

    PARTSLIST is the named range I have given the list which is B56140 and from where D9 on the PARTS worksheet gets it information

    Column D56140 of the PARTS worksheet contains the names I want to display and as it is the 2nd column in the PARTSLIST named range I have assumed it would be referenced 0,1,2 so 1 is column D?

    Can you give me a pointer on where I have gone wrong?

    Thanks
    Cheers

    Steve

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

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    1 is the first column, so the column you are already doing the match with the part number. You need 2 or higher.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='pieterse' post='793347' date='15-Sep-2009 07:39']1 is the first column, so the column you are already doing the match with the part number. You need 2 or higher.[/quote]

    Thanks Jan Karel

    Last night I could have sworn that I tried 0,1,2,3 but none worked and then hey presto it did today

    Thanks again
    Cheers

    Steve

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

Posting Permissions

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