+ Reply to Thread
Results 1 to 2 of 2

find closest range from a different sheet and return a set of values for each

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Concord, NH
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question find closest range from a different sheet and return a set of values for each

    the descriptive title probably just confuses you because it confused me as i wrote it. i have included the worksheet that i need help solving. basically my issue is this: i have a measurement for the peak STAGE in a year (the highlighted cell in the PEAKS sheet). i need to use that STAGE measurement to reference the data from the NSD sheet. i need to setup a formula that will use the STAGE measurement (highlighted value) and return a set of values (stage, area, capacity, capacity, and full) for the stage below and above the measurement. I included some notes in the spreadsheet that should make it easier to understand if i have completed screwed it up here. i really appreciate any and all help from you folks. thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: find closest range from a different sheet and return a set of values for each

    Hi jgaeta,

    Welcome to the forum.

    Try using below formula:-

    {=INDEX(NSD!A1:A37,MAX(IF(NSD!$A$6:$A$37<=PEAKS!$D$5,ROW(NSD!$A$6:$A$37),"")))}

    See attached:- HELP(2).xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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