Results 1 to 7 of 7

Use INDEX MATCH to find greater than/equal to value

Threaded View

  1. 02-07-2022, 04:04 PM #1
    Bobgiant
    Bobgiant is offline
    Forum Contributor
    Join Date
    12-24-2021
    Location
    taiwan
    MS-Off Ver
    excel 2010
    Posts
    121

    Use INDEX MATCH to find greater than/equal to value

    I need to find the value whereby the value is greater than or equal to the search term


    How do you make C4 return exactly the same as G4. C4 has formula ordered from small to large, which g4 has formula ordered from large to small. But I want formula to order from small to large and return the same result as G4.


    Untitled28.png
    Attached Files Attached Files
    Last edited by Bobgiant; 02-08-2022 at 03:27 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDEX MATCH check for Greater than or equal to date
    By vincesquare in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2021, 09:51 PM
  2. Formula to find out Greater than equal to
    By jebalia_d in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2019, 01:27 PM
  3. [SOLVED] Index match - column and row (vertical / horizontal) match - equal or greater
    By lukemc11 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-04-2018, 05:36 PM
  4. [SOLVED] INDEX MATCH where value is greater than or equal to today's date
    By Ophi352 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-23-2017, 04:14 AM
  5. [SOLVED] Need to find the largest value less than (not equal) to a lookup value using Index-match
    By Farahmand in forum Excel General
    Replies: 6
    Last Post: 12-19-2015, 10:16 PM
  6. Using VLOOKUP or INDEX-MATCH to find greater than value
    By awhitworth in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-18-2015, 03:18 AM
  7. [SOLVED] INDEX & MATCH - Want value equal or greater to ACTUAL
    By heatwave in forum Excel General
    Replies: 1
    Last Post: 08-06-2014, 08:18 AM

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