Results 1 to 13 of 13

Index Match Based on Ratio of Two Columns

Threaded View

  1. #1
    Registered User
    Join Date
    09-08-2016
    Location
    FL
    MS-Off Ver
    2016
    Posts
    23

    Index Match Based on Ratio of Two Columns

    I've attached the book. I don't want to augment my sheet with a column to run the ratio calculation. I know how to return the max ratio via an array formula, but I can't get it to work with a combination of match, offset, index, etc. It doesn't have to be an array formula either, Im sure it can be done without it, too.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDEX MATCH MATCH multiple columns with same heading
    By djm198 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2016, 02:34 PM
  2. [SOLVED] Cross Check Columns for Index Match Match
    By Harr in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 12-31-2015, 11:35 AM
  3. [SOLVED] Using Index & Match (or similar) to check two columns for a match
    By dvs in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-30-2015, 07:07 PM
  4. How to calculate a number based on the given ratio. For example a 2:3 ratio.
    By Ayoub99k in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-11-2015, 08:15 AM
  5. [SOLVED] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 PM
  6. [SOLVED] Sumifs or lookup or index/match based on columns and rows
    By ned0 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2013, 08:48 PM
  7. [SOLVED] INDEX and MATCH across multiple columns based on dropdown list
    By omni72 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2012, 03:00 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