Results 1 to 16 of 16

Excel Indexing formula to Match two criteria and find the closest match on a third criteri

Threaded View

  1. 10-29-2019, 06:33 AM #11
    XLent
    XLent is offline
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,706

    Re: Excel Indexing formula to Match two criteria and find the closest match on a third cri

    The attached is based on your original upload - with post#3 suggestion in place.

    As an Essex resident myself I'll over look the cross post ;-)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. FInd closest/nearest match in excel
    By Ribband in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2018, 09:39 AM
  2. [SOLVED] Find address of closest match/second closest match
    By L.LEE in forum Excel General
    Replies: 1
    Last Post: 11-13-2018, 11:56 PM
  3. Find closest time match with multi criteria, return another value
    By danielfinzel in forum Excel General
    Replies: 3
    Last Post: 10-19-2018, 05:45 AM
  4. [SOLVED] Formula to find closest match number in a range
    By c.davidson in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-19-2018, 05:39 AM
  5. If criteria match multiply one cell with the cell right next to one of the matched criteri
    By Luther.King in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-27-2014, 07:55 PM
  6. Double Criteria Search - Exact Match on First but Closest Match on Second
    By SPAMACCOUNT in forum Excel General
    Replies: 6
    Last Post: 01-28-2012, 06:59 PM
  7. Double Criteria Search - Exact Match on First but Closest Match on Second
    By SPAMACCOUNT in forum Excel General
    Replies: 2
    Last Post: 01-28-2012, 05:26 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1