Skip the row if the logical test is false?

**ridgelyiv** · 02-23-2011, 03:21 PM

Is there a way for the "IF" function to skip to the next row if the logical test returns "false"?

I am trying to consolidate a list from a master that I can print out for the VP for anybody who has a value higher than 10,000. If they do not meet this criteria I want to completely skip their record (the entire row) and move on to the next one.

Right now I have this:
=IF('Master SoB Prospect'!G8>9999,'Master SoB Prospect'!B8&Pipeline!$F$3&'Master SoB Prospect'!A8,"")
Which returns me "0" where I want the row to be skipped.

I have seen some similar threads but none that deal with this problem outside of VB. Is there a way to solve this using the simple IF function. If not could someone try to please simplify the VB code.

Thank you in advance for your help!

-RH

**NBVC** · 02-23-2011, 03:37 PM

Try something like:

=IFERROR(INDEX('Master SoB Prospect'!B$2:$B$100&Pipeline!$F$3&'Master SoB Prospect'!$A$2:$A$100,SMALL(IF('Master SoB Prospect'!$G$2:$G$100>9999,ROW('Master SoB Prospect'!$G$2:$G$100)-ROW('Master SoB Prospect'!$G$2)+1),ROWS($A$1:$A1))),"")

adjust ranges to suit, but try not to make them bigger than they need to be. and then confirm the formula with CTRL+SHIFT+ENTER not just ENTER and copy it down....