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 karenhayes7
.
<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)))

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic