+ Reply to Thread
Results 1 to 4 of 4

Select value based on a value being in a range

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    UK
    MS-Off Ver
    Excel 365
    Posts
    57

    Select value based on a value being in a range

    I am not sure if my title really describes what I am trying to do, so here is an example;

    I have a data table as follows;

    Min Max Value
    100 109 11
    110 119 12
    120 129 13

    I want to be able to find a value, based on a different value fitting in the Min / Max range (inclusive). For example, if I have 114 this is in the range 110 - 119 on my table, so I expect 12 back.

    How might I go about this on Excel 2010?

    Thanks in anticipation

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Select value based on a value being in a range

    Supposing the value you need to lookup is in E3 try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-05-2011
    Location
    UK
    MS-Off Ver
    Excel 365
    Posts
    57

    Re: Select value based on a value being in a range

    Thanks, that works a treat.

    I am not sure I know how it works, but a bit of googling later will put that right.

    Much appreciated

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,453

    Re: Select value based on a value being in a range

    This link will certainly help. With XL2010 you can also use the SUMIFS function. And don't forget the " evaluate formula" tool in the Formulas ribbon

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Select a range based on a cell value
    By Thug in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2013, 05:09 PM
  2. [SOLVED] Select range based on cell value
    By forfiett in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-22-2013, 04:53 PM
  3. Select Range Based on Find
    By Nobranalon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2013, 02:32 PM
  4. select range based on a cell value
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-19-2008, 04:31 AM
  5. [SOLVED] Select sheets based on what is in a range.
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-29-2006, 01:15 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1