Add ROW based on MATCH using >= number value

[cedarhill]

I am adding rows of data to a worksheet based on criteria found in another worksheet. I've done this with two other worksheets in the same workbook without a problem.

In this case, I'm adding rows if the Utilization in the Master worksheet is >=150% and the logic I am using (which does not work) is:

Please Login or Register  to view this content.

The value I get back looks like it is the column header "Seq #" in the Master??

However, in a similar worksheet looking for a MATCH for a simple "Y" in another column works just fine, as follows:

Please Login or Register  to view this content.

I've attached the sample spreadsheet and would appreciate some help with this one.

[rylo]

Hi

Try

=IF(ROW($B3)-ROW($B$3)+1>$I$1,"",INDEX(Master!$B$1:$B$1000,SMALL(IF(Master!$X$3:$X$1000>=1.5,ROW(Master!$A$3:$A$1000),99999),ROW($B3)-ROW($B$3)+1)))

I don't know how your other sheet is set up, but in this case, it is looking at the header row and bringing back a result that is >=1.5. The above formula will ignore the first 2 rows in the testing process.

HTH

rylo

[cedarhill]

That did work...very nicely.

I had already tried changing the X1:X1000 to X3:X1000 but, in all the different iterations I tried, I never thought to also change A1:A1000 to A3:A1000.

I guess, when you start to get into some of these more complex function combinations, it truly is easy "to get lost in the forest for all the trees"...or that's my version of the old saying.

Thanks, again.