Forum Discussion
Search for multiple values
Hey guys, I was wondering if anyone knows how you can search for multiple different values in an excel spreadsheet at once? I am attempting to search for multiple unique document numbers (BC9972...
In the absence of seeing your actual spreadsheet, or sample thereof, I can only suggest you try the FILTER function. You might have to play a bit with your criteria, using OR to allow for several possibilities.
If you can't resolve it, come back with a sample of the sheet itself so we don't have to create our own.