blueexcel123
New Member
- Joined
- Jan 23, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi all!
I am trying to find a simple way to search for multiple items at the same time in one excel sheet, and then, hopefully, create a new sheet with all the correct matches. Ideally, I would cross-reference the data between two sheets, and only the matches would appear. I am not an excel expert, so I am trying to find a simple way to do this or at least a simple way to search for a list of terms in one sheet, rather than 1 at a time. Everything I have found thus far (excel formulas to search for multiple words, advanced filtering) doesn't quite seem to suit my needs. Any guidance would be GREATLY appreciated!
Using the quick snips as an example below, I would want to copy all the names from Sheet 2 at the same time, and search them in Sheet 1 as one search. Sheet 1 would then only display the matching names.
Sheet 1: Sheet 2:
I am trying to find a simple way to search for multiple items at the same time in one excel sheet, and then, hopefully, create a new sheet with all the correct matches. Ideally, I would cross-reference the data between two sheets, and only the matches would appear. I am not an excel expert, so I am trying to find a simple way to do this or at least a simple way to search for a list of terms in one sheet, rather than 1 at a time. Everything I have found thus far (excel formulas to search for multiple words, advanced filtering) doesn't quite seem to suit my needs. Any guidance would be GREATLY appreciated!
Using the quick snips as an example below, I would want to copy all the names from Sheet 2 at the same time, and search them in Sheet 1 as one search. Sheet 1 would then only display the matching names.
Sheet 1: Sheet 2:
