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

    lookup with ranges

    I would like to have a lookup table return a value based on ranges; e.g.,
    Where my ranges are
    0 to <250
    >=250 to <500
    >=500 to <1000
    >1000

    And the results would look like:

    Lookup value result
    453 red
    667 green
    123 blue
    1234 orange



    I think if I set up my lookup formula as:
    =VLOOKUP(A1,lookup_range,2,true)

    And use this lookup table:

    0 blue
    250 red
    500 green
    1000 orange

    It should work. Is there any way this could trip me up?
    Thanks!
    Last edited by jepalmer; 2011-08-15 at 10:01.

  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
    That is how I would set it up. [Note that it should be >=1000, not >1000 in your description]

    Steve

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    thanks!

Posting Permissions

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