Forum Discussion
How to identify a row number considering category my values falls into
Hello. I have a value of X (let's say it's 1000). I want to identify a row that X falls into between the two values of columns A and B, for example ROW Column A Column B 1 Min ...
=MATCH(1,(D2>=$A$2:$A$4)*(D2<=$B$2:$B$4),0)+1You can try this formula if you want to return the row number. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.