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
Bookmarks