Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    vblookup problem

    Good Afternoon all,

    Attached is a sheet that has an excerpt from a list that I am using the vblookup formula with and it is returning the wrong answer 2 times within the column. Please review and let me know what I have done to make this go crazy !
    Much thanks in advance for all the help!!
    Attached Files Attached Files

  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
    You must use a zero (0) to designate finding an exact match, since your numbers are not sorted in ascending order:
    =VLOOKUP(C3,$E$3:$F$10,2,0)

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts

    many thanks

    Thank you sdckapr .... much appreciated for the quick reply... this will make my day much better

  4. #4
    New Lounger
    Join Date
    Feb 2010
    Location
    East Brunswick, NJ
    Posts
    15
    Thanks
    1
    Thanked 3 Times in 2 Posts
    You can use this formula to avoid problems with having your data sorted:
    =INDEX($F$3:$F$10,MATCH(C3,$E$3:$E$10,0)). The Match statement finds the first occurrence of the thing you are looking for (the zero is used to force an exact match), and the index function picks the corresponding value. If you use named ranges, it looks simpler.

    Norm

Posting Permissions

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