+ Reply to Thread
Results 1 to 3 of 3

Right to left conditional lookup

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Netherlands
    MS-Off Ver
    2016 (64-bit)
    Posts
    46

    Right to left conditional lookup

    I'm working in regression model, which needs some tweaking. It needs to be able to exclude certain weeks which are classified as an outlier.

    I've added an example file.

    In rows 2 and 3 are my data which can go on indefinatly. And in row 18 the desired result, which is always 26 weeks.
    Cell AB18 should look for the last week with a 'NO' value in row 3. Based on that value in AB18 is should look for the previous 25 weeks which were no outliers.

    Any ideas on how I can accomplish this?

    Thanks!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Excel 2019
    Posts
    447

    Re: Right to left conditional lookup

    Hi

    please find the attached...
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-21-2012
    Location
    Netherlands
    MS-Off Ver
    2016 (64-bit)
    Posts
    46

    Re: Right to left conditional lookup

    Thanks Sadath, it works great!

    It's a comepletely different approach to the problem. I tried working with dynamic named ranges and offset. This is a much simpler solution.

+ 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] Left Lookup
    By clattenburg cake in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-28-2013, 12:44 PM
  2. Using Lookup instead of Index/Match for left lookup
    By teylyn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2008, 09:20 PM
  3. Lookup to the left
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 06-18-2008, 06:21 AM
  4. Lookup to the Left
    By tuph in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2006, 06:11 PM
  5. lookup/left
    By via135 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2006, 09:43 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