Results 1 to 10 of 10
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: vlookup information (2003)

    You'll have to provide more details. What do you want to appear in the display sheet, where does it come from, etc.
    If possible, attach a small workbook demonstrating what you want to do.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: vlookup information (2003)

    I do not completely understand your setup or what you want. Could you elaborate or even perhaps add a sample file?

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup information (2003)

    Here is a sample sheet that shows what I am trying to do. I highlighted the vlookup formula. Thanks.

  4. #4
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    vlookup information (2003)

    Hello,
    I have a spreadsheet that has two sheets. One contains information for dropdown menu and the second is for displaying the information. On the display sheet, I want to populate b2 base on the selection of a1. How can I do it? I thought about a index or vlookup values, but am having trouble with it. Thanks.

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

    Re: vlookup information (2003)

    So you already have a working VLOOKUP formula. What exactly is the problem? Please try to be precise.

  6. #6
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup information (2003)

    I thought I did, but if put a name on the highlighted field, it won't display the value next to it which is what I wanted to do. I also wanted to make the name a drop down option. Thanks.

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

    Re: vlookup information (2003)

    See attached version. I created a dynamic named range NameList, you can see its definition in Insert | Name | Define. It will resize automatically as you add or remove names.
    I moved the highlighted cells to the other worksheet, added a validation dropdown list to the first cell (see Data | Validation), and modified the VLOOKUP formula.

  8. #8
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Cambridgeshire, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup information (2003)

    Hans,

    One last question. When there is no value in the formula (vlookup) #N/A appears. How can I have it so nothing appears if nothing is selected? Thanks.

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

    Re: vlookup information (2003)

    Use this

    =IF(A1="","",VLOOKUP(A1,OFFSET(NameList,0,0,,2),2, FALSE))

    or

    =IF(ISNA(VLOOKUP(A1,OFFSET(NameList,0,0,,2),2,FALS E)),"",VLOOKUP(A1,OFFSET(NameList,0,0,,2),2,FALSE) )

  10. #10
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: vlookup information (2003)

    Thank you Hans.

Posting Permissions

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