Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Complex Left Lookup (Excel 2003)

    Hi again to all the resident Excel gurus...

    Here is today's question: I'd like to create a formula that will do a left lookup and then select the second (or third or fourth) instance of the lookup value. I've been playing with this for a while, and I feel like I'm almost there, but I can't seem to nail it down.

    As always, many thanks for all the great help...

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

    Re: Complex Left Lookup (Excel 2003)

    Try <!profile=sdckapr>sdckapr<!/profile>'s VLookupAll function from <post:=395,235>post 395,235</post:>.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Complex Left Lookup (Excel 2003)

    Thanks, Hans. Very much appreciated.

  4. #4
    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: Complex Left Lookup (Excel 2003)

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>I think the VLIndex is more appropriate since the OP wants to select a particular one (2nd, 3rd, etc). The VLookUpAll finds all of them and puts them together...

    Steve

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

    Re: Complex Left Lookup (Excel 2003)

    OK, you're correct. Same post, though. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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