Forum Discussion
Searching multiple worksheets for different numbers simultaneously in Excel
Is it possible to search multiple worksheets for different numbers simultaneously in Excel? Using CTL-F isn't working for me.
For example, can I search 10 different worksheets all at once for the numbers 137, 142, and 154 simultaneously in Excel?
Thanks for any advice you can offer!
20 Replies
Hi,
As suggested by Detlef_Lewin , After pressing Ctrl + F, you can Go to "Options" and change the scope to "Within Workbook".
That will run your search across the whole workbook which includes your 10 worksheets.
Best Regards.
Afraid that doesn't work, question was about simultaneous search.
- Good catch Sergei...I have used "Within Workbook" but need simultaneous search for multiple numbers...any suggestions?
- My suggestion is to consolidate all sheets to one table and the search by sql.
- Could I use Microsoft Access instead?
If output is entire row in the range for which criteria is met, as variant that could be like
=LET( criteria, {137;142;154}, k, SEQUENCE(, ROWS(criteria), , 0), combine, VSTACK(Sheet1:Sheet3!$A$1:$Z$1500), FILTER( combine, BYROW( combine, LAMBDA(v, SUM( MMULT( k, --(v = criteria) ) ) ) ) ))assuming you are on 365
Using CTRL+F:
Goto the "Options" and change the scope to "Within Workbook".
Notes:
The search is always in the complete workbook.
The settings will remain until changed.
You can only search for one number at the time.
