My Data Range is B2:G10 having 4 columns B,C,D & E. These 4 Columns are ‘continuous’ & have values which are either ‘INCREASING’ from B to E or ‘DECREASING’ from B to E.
Reference range is from G2:G10
Output required:
1. I2=’Nearest’ value from B to E with reference to G
2...