+ Reply to Thread
Results 1 to 3 of 3

Match or Higher than

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    uk
    MS-Off Ver
    Excel 2013
    Posts
    99

    Match or Higher than

    Hi

    I have a working formula that has 4 match criteria of which one of them should be the same or be higher than another cell, currently it is only working if higher than the other cell.

    Here is my formula: =IF(AND(EXACT($A2,$F2),D2>H2,EXACT($B2,$G2),C2<=2,C2>=1),15,"")

    D2>H2 i am missing maybe a match symbol i.e (D2=166 or more & H2=166) is supposed to be a match but as it stands now (D2=166 & H2=166) is not registering but it will register

    when (D2=167 & H2=166), it needs to be the same or higher than.


    Thanks

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,632

    Re: Match or Higher than

    just
    D2>=H2
    ?
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    01-16-2014
    Location
    uk
    MS-Off Ver
    Excel 2013
    Posts
    99

    Re: Match or Higher than

    Perfect Thank you

+ 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. [SOLVED] Lookup/Index/Match to Return Value of Higher number rather than lower# when inbetween
    By ReedDOT in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2013, 11:56 PM
  2. return the NEXT higher match based on two criteria
    By STban73 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2013, 11:14 AM
  3. Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  4. Replies: 7
    Last Post: 03-22-2010, 05:22 PM
  5. [SOLVED] need to select closest match using vlookup if it higher or lower
    By vlookup help pls in forum Excel General
    Replies: 1
    Last Post: 03-01-2006, 03:35 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