ASAP HELP..if formula is false how do i get it to go to next line

[xania]

We are trying to take only specific information from one worksheet to print
it on another worksheet in the same workbook, if it matches the specified
criteria. We have the following
=if(or('22'!b21,="drf6",'22'!c8="marc"),'22'!b8) which works for the criteria
we want on the sheet, except for when the criteria is not met it puts FALSE
in our cell and we want it to look at the next line and not input FALSE or
leave a blank line but continue on until "drf6" or "marc" is found again. If
the criteria is true that is the only info we want to print on the second
worksheet, no blank lines or false statements.

 

[Shane Devenshire]

Hi,

Try using Auto Filter or Advanced Filter with your condition, then copy the
results to the second sheet.

 

[xania]

isn't there a formula for this?.....hundreds of people use this workbook and
we are trying to prevent human error.....so we don't want anyone to copy and
paste. we just want our formula to continue its search through the rest of
work sheet one and not end .

 

[Fred Smith]

No. There isn't "a formula for this". If statements look at exactly the
cells you identify. They don't "continue on".

That's why Excel has lots more features which deserve your attention.
Filtering is one of the best.

If you're serious about going to the effort of preventing human error, you
will need a macro.

Regards,
Fred.

 

[xania]

What about some +1 function or something? does that go to the next line and
start my formula all over.

 

[Fred Smith]

Sorry, the answer is still no.

Regards,
Fred,

What about some +1 function or something? does that go to the next line
and
start my formula all over.

 

[T. Valko]

=if(or('22'!b21,="drf6",'22'!c8="marc"),'22'!b8)

we want it to look at the next line

And what would the next line be?
=if(or('22'!b22,="drf6",'22'!c9="marc"),'22'!b9)

???