Index formula questions

taylorwood09 Posts 1 Registration date Monday July 17, 2017 Status Member Last seen July 17, 2017 - Jul 17, 2017 at 04:31 PM
I have an index formula that will be calculating price points based on the values entered into the excel document. Is there a way to make sure that there isn't a value showing in the cell that has the formula until a value is entered into one of the other cells?

Here is the formula: =INDEX(D6:D11, SUMPRODUCT(--($L$8<=C6:C11), --($L$8>=B6:B11), ROW(A1:A6)))