+ Reply to Thread
Results 1 to 7 of 7

vlookup Question about descending numbers

Hybrid View

  1. 11-12-2007, 03:53 PM #1
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    vlookup Question about descending numbers

    Quote Originally Posted by slx
    In terms of descending order, it works up until i get to under 100. IDs 1-99 cant seem to be found.
    Hmmmm....here's a thought:

    Check numbers 1-99. Are they really numbers? or are they text?
    If those cells are formatted as "text" or contain text (eg '099) and the VLOOKUP is searching for numbers, those text values won't be recognized.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  2. 11-12-2007, 04:46 PM #2
    slx
    slx is offline
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270
    all the numbers in the first colum, my ID column are numbers. Its just that when i put them in descending order, vlookup can't seem to figure out where the IDs 1-99 are, but when its in ascending order, Vlookup has no problems at all.

    perhaps i should use the index function instead?

    Just that vlookup has been workin pretty well for me up until now.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1