I cant find a solution around this
Description of the problem is on the first sheet in red font
I want to look up what is the closest value to cell C15 (Highlighted in Red) from sheet 2 column (J) TMP Blue and return the value from the same raw but from Column (I)
Every time I try it, it gives me the closest value to C14 from Column (I) instead of the value from the same RAW
For example if I have a value of 3 in C14, it would look up value 2.9 from column (J) and return 2.5 from column (I) instead of 20
Thanks
Bookmarks