I need help fixing a formula. I receive the #REF! error and the wrong answers at times and would like some help fixing it. I need to find the next greater value of a value selected. The values reside in column C and the values to choose between for the next greater value reside in columns D:G and the formula itself is in column H.
C2: 0.9833 - Find next greater value.
H2: #REF - #REF! Error
I2: .9865 (Is what the answer should be in H.)
I attached a spreadsheet that has other examples and the formula itself. Thanking you in advance for any and all help.