=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)

???

--
Biff
Microsoft Excel MVP


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

"Fred Smith" wrote:

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" wrote in message
...
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 .

"Shane Devenshire" wrote:

Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"xania" wrote:

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.