+ Reply to Thread
Results 1 to 2 of 2

Lookup Formula to Return Lowest Value Except for 0%

  1. #1
    Forum Contributor garrett.grillo's Avatar
    Join Date
    06-19-2011
    Location
    San Francisco, California
    MS-Off Ver
    Excel 2010
    Posts
    188

    Lookup Formula to Return Lowest Value Except for 0%

    Hi Excel Forum Team,

    Please see the example excel sheet for reference.

    I need a formula that will reside in the Rate Percent ("H") column and will lookup and match the Project Number ("F") column and the Fund Number ("G") column with the information contained in the Table.

    This formula will return the lowest Rate Percent, but however it will not count 0% as the lowest Rate Percent unless that is the only value available in the lookup.

    Please let me know if I can answer any questions of further clarify the problem.

    Thank you for your time and help.

    Garrett
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,220

    Re: Lookup Formula to Return Lowest Value Except for 0%

    Try array entering this formula in H4 and fill down. If you arenít familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 05-31-2017 at 10:27 PM.
    Dave

+ 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. How to return the column based on the lowest value of the lookup value?
    By alvinmathew88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2017, 05:41 PM
  2. [SOLVED] Formula to return the lowest value in differents tables
    By Keldion in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2016, 06:40 PM
  3. [SOLVED] Lookup formula to find lowest value with variable lookup criteria
    By brharrii in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-27-2015, 03:00 AM
  4. Macro to lookup and return lowest product price from specific website
    By timmy1254 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2014, 12:02 AM
  5. Replies: 5
    Last Post: 07-07-2013, 03:39 PM
  6. Lookup next lowest number and return corresponding cell
    By R.C.B. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-23-2013, 05:29 PM
  7. [SOLVED] Execl formula return the lowest value
    By Excel Lowest Value in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-25-2006, 09:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1