Results 1 to 7 of 7

INDEX MATCH - replacing the fixed values with fluid formulas

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    toronto, canada
    MS-Off Ver
    Excel 2013
    Posts
    3

    INDEX MATCH - replacing the fixed values with fluid formulas

    7H3uWiW.png

    Hello, I wish to have the formulas in the above image:
    1. Search for the most recent entry.
    2. Find the lowest value in the row.
    3. Report that value and the header.

    I've been unable to get the formula to report the result without using a fixed column and row value. Am I using the right formulas? Thank you! Much appreciated folks.
    Last edited by audiberry; 01-14-2020 at 04:28 PM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need INDEX MATCH formula with FIXED workbook but DYNAMIC sheet
    By mbb19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2018, 02:43 PM
  2. [SOLVED] Replacing formulas with values
    By jh51745 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2018, 10:35 AM
  3. Replacing formulas with values
    By jh51745 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2018, 03:17 PM
  4. Index Match Formula, can index be fixed?
    By herschen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2015, 08:28 PM
  5. replacing VLOOKUP with INDEX MATCH function
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2012, 05:08 PM
  6. [SOLVED] Index & Match returning incorrect value. Arrays fixed and exact match used.
    By SDes in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 08:29 PM
  7. Replacing Formulas with Values
    By Raman325 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2005, 02:54 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