Results 1 to 7 of 7

Thread: VLOOKUP (2007)

  1. #1
    New Lounger
    Join Date
    Jan 2007
    Location
    Melbourne, Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VLOOKUP (2007)

    Hi all. Can anyone tell me if I can bring over comment tags in a VLOOKUP.

  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 (2007)

    Not with a Vlookup or any excel built-in function. It would require a macro as some kind of user defined function. Can you elaborate on what you want/need the function to do?

    Steve

  3. #3
    New Lounger
    Join Date
    Jan 2007
    Location
    Melbourne, Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP (2007)

    I am setting up worksheets. First sheet with 2 columns- Column A - Product code. Column B - Description (with comments). Second sheet I have a VLOOKUP where I enter the Product code and bring over the description from column B, but I need the information stored on the comments to come over with it.
    Hope this makes sense. Also is there a way to stop the #N/A error message from showing

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

    Re: VLOOKUP (2007)

    Instead of using comments, I'd use column C on the first sheet to enter additional information about the product.
    You can then use two VLOOKUP formulas on the second sheet - one to retrieve the description and one to retrieve the additional info ('comment').
    To suppress #N/A for product codes that do not exist, you can use ISNA. For example:

    =IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$C$1000,2,FALSE)), "",VLOOKUP(A2,Sheet1!$A$2:$C$1000,2,FALSE))

    for the description, and

    =IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$C$1000,3,FALSE)), "",VLOOKUP(A2,Sheet1!$A$2:$C$1000,3,FALSE))

    for the 'comment'.

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VLOOKUP (2007)

    <P ID="edit" class=small>(Edited by wdwells on 14-Feb-08 11:56. Attachment updated)</P>If you want to maintain something of the look and feel of comments; I offer the attached sample.
    Attached Files Attached Files
    Regards
    Don

  6. #6
    New Lounger
    Join Date
    Jan 2007
    Location
    Melbourne, Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP (2007)

    Thank heaps HansV. I'm now going to try it. I'll let you know how it goes

  7. #7
    New Lounger
    Join Date
    Jan 2007
    Location
    Melbourne, Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP (2007)

    Hello Don I am having trouble opening your file. I try again on another computer and let you know if it works. Thank you very much for your help

Posting Permissions

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