Results 1 to 8 of 8

LOOKUP MIN.VALUE using HLOOKUP or INDEX, MATCH?? - NEED ADVICE

Threaded View

  1. #1
    Forum Contributor meyero90's Avatar
    Join Date
    03-24-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    202

    LOOKUP MIN.VALUE using HLOOKUP or INDEX, MATCH?? - NEED ADVICE

    Hello,
    I am trying to find out which formula can be used to look up a name and return the min. value within the corresponding column.
    The min value results should be returned in C15, while the formula should lookup that min value in the index B6:AP8.
    As of now, I simply entered the min value manually in C15, but hope to find a formula that will lookup for that min value in B6:AP8 and report it in C15...
    Thank you in advance for your help
    attached is a spreadsheet to help illustrate my problem
    Attached Files Attached Files
    If I helped, Don't forget to add to my reputation (click on the little scale)
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hlookup/index/match
    By doughnut_jimmy in forum Excel General
    Replies: 0
    Last Post: 09-08-2014, 07:57 AM
  2. Need Advice on Formula Index+Match (Multiple Matches) + IF
    By cychua in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-05-2013, 05:08 AM
  3. [SOLVED] Index/match/hlookup?
    By Shadefalcon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2013, 08:34 AM
  4. HLOOKUP using MATCH and INDEX
    By cocostar88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-22-2013, 09:50 AM
  5. Index and Match or Hlookup
    By pauldaddyadams in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2011, 04:37 AM

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