+ Reply to Thread
Results 1 to 6 of 6

Priority based lookup

Hybrid View

  1. #1
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: Priority based lookup

    This seems to work:
    Formula: copy to clipboard
    =CHOOSE(VLOOKUP(C3,$L$3:$M$9,2,0)-VLOOKUP(C8,$L$3:$M$9,2,0)+2,C3,INDEX(C$2:C$11,MATCH(MIN(C11,C6),C$2:C$11,0)-3),C8)

    Formula: copy to clipboard
    =CHOOSE(VLOOKUP(C3,$L$3:$M$9,2,0)-VLOOKUP(C8,$L$3:$M$9,2,0)+2,C6,MIN(C11,C6),C11)
    Attached Files Attached Files
    Last edited by Jacc; 07-04-2019 at 12:11 PM.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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. [SOLVED] Priority Based Lookup
    By virencm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-18-2018, 08:45 PM
  2. [SOLVED] Set a priority based on a date
    By mlennox2701 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-14-2017, 04:29 AM
  3. Replies: 2
    Last Post: 05-10-2017, 07:32 PM
  4. Format Row Based on Priority
    By markusvirus in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-28-2017, 05:50 AM
  5. [SOLVED] Calculating Date Based on Priority
    By MrPifster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-16-2017, 05:38 PM
  6. [SOLVED] Priority setting based on five conditions
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2016, 10:40 AM
  7. Result based on existance & priority
    By anetsurfer in forum Excel General
    Replies: 4
    Last Post: 12-05-2009, 02:20 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