Oct 04 2019 07:19 AM
Hello everyone,
I want to make an automatic cell with a formule, surrounded cell with blue. I want it so it reads the cell in front, underlined blue in the table on the right, surrounded with red. the next problem is then its bases on the number in front of the comma, first column and behind the comma top row. Note this is only half of the total table! This is the biggest problem cause it is not a small table.
Hopefully someone can help me!
thanks in advance
Oct 05 2019 12:44 PM
Thank you, but I did one mistake. At least. The point is that when we go from zero degreeC up to water or down to ice vapor pressure is different
MATCH find first in sequence row with zero. Thus if we have temperature below the zero but higher than -1, we have to jump on next from found row.
Thus I updated the formula
=INDEX($P$4:$Z$60,MATCH(TRUNC(F5),$O$4:$O$60,0)+0.5*(1-SIGN(F5))*(TRUNC(F5)=0),(10*CEILING(ABS(ROUND(F5-TRUNC(F5),2)),0.1)+1))
by adding to MATCH
+0.5*(1-SIGN(F5))*(TRUNC(F5)=0)
It becomes longer, but I hope more correct. Result is
Attached file is corrected