Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Limitation In VLookUp (Office XP)

    Hi

    VLookup will stop at the first value it find and ignore the rest if there is another of the same value.
    Is there a workaround to find two of the same value but with different content using two different workbooks, workbook 1 being the table where you want to see the input of the find value and workbook 2 being the range of value assigned. eg. Product A with 20 units locate in Shelf A and Product A with 5 units locate in warehouse?
    thanks, kun

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

    Re: Limitation In VLookUp (Office XP)

    VLOOKUP returns a single value to a single cell. How would you expect it to return multiple values?

  3. #3
    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: Limitation In VLookUp (Office XP)

    I am not sure exactly what you want/need. Could you elaborate?

    If your goal is to use VLookup to get multiple items then see the custom function that I wrote and posted in
    Re: Lookup more than one row (2000). Perhaps this code could be modified to do what you want...

    Steve

  4. #4
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limitation In VLookUp (Office XP)

    Just wanted to say thats some cool code /custom function !

    I'm sure that will come in handy as I have often wanted to get duplicate vales from a VLookup. I write 'temp' subs all the time - should have thought of making custom functions!!

    Thanks Steve <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Thanks,

    pmatz

  5. #5
    Star Lounger
    Join Date
    Jun 2005
    Location
    Singapore
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Limitation In VLookUp (Office XP)

    Steve,

    Thanks you for the response. I haven't try your code I am wondering whether we can to use function : index and match or just index?

    thanks, kun

  6. #6
    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: Limitation In VLookUp (Office XP)

    It depends on what you want to try (my functions are for VLOOKUP or HLOOKUP, not for match)

    Could you elaborate on what you are trying to do. I don't understand your intial question.

    Steve

Posting Permissions

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