Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    VLOOKUP function (2002)

    Just a question to confirm what I think happens in a lookup table. I work in water years (October through September) and had monthly data I want to pull out in a vlookup command (=vlookup(month(a2),Data_Range,2,false). The Data_Range was in numbers starting with 10 ( i.e. 10, 11, 12, 1, 2,3,4,5,6,7,8,9). The lookup table didn't work until I sorted the data so that it was in numberical order satrting with 1. My question is, does lookup data have to be sorted in ascending order or is there something else going on?
    Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VLOOKUP function (2002)

    If the last parameter is True, then the table must be sorted on the lookup column. If the last parameter is false, then there is no requirement that the table be sorted.
    Legare Coleman

Posting Permissions

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