+ Reply to Thread
Results 1 to 5 of 5

What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39"

  1. #1
    Forum Contributor
    Join Date
    08-01-2016
    Location
    China, beijing
    MS-Off Ver
    2016
    Posts
    114

    What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39"

    I want to find the cell with the minimal value in the range(m25:m39), and then get row number of the cell, and at last get the value at column 'D' with the same row of the cell with the minimal value.

    =CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:M39,0),"0"))

    but the statement above is wrong how to fix it?
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:

    try: =CELL("contents",INDIRECT("D"&TEXT(MATCH(MIN(M25:M39),M25:M39,0),"0")))

  3. #3
    Registered User
    Join Date
    05-04-2017
    Location
    MALAYSIA
    MS-Off Ver
    2007
    Posts
    34

    Re: What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:

    Also try: =index(d25:d39,match(min(m25:m39),m25:m39,0),1)

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:

    ...Or just:
    =INDIRECT("D"&TEXT(MATCH(MIN(M25:M39),M25:M39,0),"0"))

    Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: What's wrong with my this formula "=CELL("contents","D" & TEXT(MATCH(MIN(M25:M39),M25:

    I think that naeeim07 has the correct answer for you. However the ,1 at teh end of the formula is not needed. It can besimply:

    =INDEX(D25:D39,MATCH(MIN(M25:M39),M25:M39,0))
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  3. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  4. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  7. Replies: 5
    Last Post: 10-12-2010, 06:46 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