I have a formula obtained from you guys recently that I cannot seem to make work when trying to use it for the same purpose, but when attempting to extract info from another sheet. I need a better understanding of the following formula to understand how it works so that I can adjust it for other uses. =IFERROR(INDEX('Estimate Detail 1'!$F$12:$F$2447,SMALL(IF(0<'Totals by Cost Code'!$V$12:$V$2447,ROW('Totals by Cost Code'!$V$12:$V$2447)-ROW('Totals by Cost Code'!$V$12)+1),ROW(2:2))),"")
I'm struggling with the rows portion of the formula, I believe.
Solved by E. J. in 28 mins