Forum Discussion
If Then Shortcut
Hi, I'm trying have a cell look about 100 cells on a particular row (with formulas) for the first cell that has a number greater than 0 (zero) and then look and then look at another row of 100 cells ...
=INDEX($A$2:$V$2,SMALL(IF(A3:V3>0,COLUMN(A:V)),1))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.