Look up values between a range

**MarginofBuffett** · 11-27-2010, 05:42 PM

Hi,

I have a spreadsheet that displays output whenever the corresponding cell returns a 1. The problem is, sometimes the cell will be .99999996, and the output will not show because the MATCH function I'm using is looking for a 1, not .99999996. I was wondering if I could set up a MATCH function that looks for a range of values? I've attached a spreadsheet below.

**martindwilson** · 11-27-2010, 06:37 PM

let's play hunt the formula!

**MarginofBuffett** · 11-27-2010, 08:10 PM

Sorry, the formula is in Cell C2 on the "Log Returns" sheet.

**martindwilson** · 11-28-2010, 03:53 PM

where are the cells with .99999996 ?

**MarginofBuffett** · 11-29-2010, 12:41 AM

cell AA22 on the "Optimizer" Sheet.

**DonkeyOte** · 11-29-2010, 03:39 AM

Adjust the values in B such that they are Rounded to nearest whole number.

Please Login or Register  to view this content.

Then I would suggest

Please Login or Register  to view this content.

in a model such as this it's generally good advice to avoid use of Volatile functions like INDIRECT - as you can see in this instance INDEX is equally effective and is non-volatile.