+ Reply to Thread
Results 1 to 5 of 5

Range of Numbers Lookup

  1. #1
    Registered User
    Join Date
    05-03-2024
    Location
    Missouri
    MS-Off Ver
    Google Sheets
    Posts
    1

    Range of Numbers Lookup

    Hello, I need help with a formula for looking up a range of numbers in different cells and giving me the highest number within that range.
    IE:
    My range is 25-29
    I'm looking up in cells s10:at10
    Now I want the highest number within my range from those cells.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2508 Win 11
    Posts
    24,959

    Re: Range of Numbers Lookup

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,317

    Re: Range of Numbers Lookup

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by JohnTopley; 05-04-2024 at 05:31 AM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,133

    Re: Range of Numbers Lookup

    This works in Excel. You could try it in Google Sheets:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See: https://support.google.com/docs/answer/7013817?hl=en
    Last edited by TMS; 05-04-2024 at 05:22 AM. Reason: Add reference
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    49,133

    Re: Range of Numbers Lookup

    Neater: =LET(rng,S10:AT10,MAXIFS(rng,rng,">=25",rng,"<=29"))

    See: https://support.google.com/docs/answer/13190535?hl=en

+ 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. lookup if a number is within X of a range of numbers
    By td3201 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-30-2024, 10:03 PM
  2. [SOLVED] lookup in range of numbers
    By Stekke76 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-13-2018, 06:57 AM
  3. Lookup Range Between 2 Numbers & 3rd Value
    By dleiman in forum Excel General
    Replies: 4
    Last Post: 04-29-2010, 12:29 PM
  4. How lookup numbers between range numbers in 1 cell ?
    By termal in forum Excel General
    Replies: 4
    Last Post: 02-06-2010, 06:57 AM
  5. Lookup a range of numbers
    By Dolphinv4 in forum Excel General
    Replies: 4
    Last Post: 05-24-2005, 06:32 AM
  6. Lookup a range of numbers
    By Dolphinv4 in forum Excel General
    Replies: 4
    Last Post: 05-24-2005, 06:31 AM
  7. [SOLVED] Lookup a range of numbers
    By Dolphinv4 in forum Excel General
    Replies: 5
    Last Post: 05-23-2005, 09:06 PM

Tags for this Thread

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