Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Want to search for multiple values using this formula.

Aug 3, 2011 4:31AM PDT

<span id="INSERTION_MARKER"><span id="INSERTION_MARKER">I have been using this formula to search one sheet and export info to another sheet based on one value (Watterson). I now need it to do this for multiple values (Watterson & Wright).
<span id="INSERTION_MARKER">


=iferror(filter(Sheet1!A:Z;search("Watterson",Sheet1!F:F)))


Discussion is locked

- Collapse -
Answer
Re-post
Aug 4, 2011 5:34AM PDT

I've re-posted to make reading it easier.

I have been using this formula to search one sheet and export info to another sheet based on one value (Watterson). I now need it to do this for multiple values (Watterson & Wright).

=iferror(filter(Sheet1!A:Z;search("Watterson",Sheet1!F:F)))

Mark, (for karenhayes7Cool.

- Collapse -
Please clarify
Aug 4, 2011 5:39AM PDT

Do you now want to search for "Watterson & Wright" together, or for "Watterson" and for "Wright"?

If you mean separately for Watterson and for Wright, then I can't see how to do it in one formula.

But a macro could do it. Set the macro to run both formulas, one after the other, then end the macro. it would be lightening fast, (well, depending the size of the job of course).

Mark