Hello everybodey. I have finished my formula and till now its working everything, but i need to put a second condition inside that. Here is my formula to match a specific value in a row that have 2 conditions >=1.80 and <=1.9:
Formula: {=INDEX(A2:GR2,MATCH(TRUE,INDEX((A2:GR2>=1.8),0),0))}
I dont know where and how to put the second condition *(A2:GR2<=1.9)
Formula: {=INDEX(A2:GR2,MATCH(TRUE,INDEX((A2:GR2>=1.8),0),0))}
I dont know where and how to put the second condition *(A2:GR2<=1.9)