Word search in Excel

Closed
Nate - Jun 6, 2011 at 09:11 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 6, 2011 at 01:40 PM
Is there a function that can search the entire worksheet (all columns & rows) for a given word that the user inputs and then the output would be the cell(s) location(s) that contains the user supplied word that was the input? For example: A1 is the cell that all queried words will be entered by the user and B1 is where the results are returned. If we are wanting to find all locations of the word "Cost" which are in G8, Y2 and F26. Then after Excel performs the search it would return in B1 "G8,Y2,F26". Is this something that's possible? Thank you so much for the help!
Nate
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 6, 2011 at 01:40 PM
A simple find can give you that. If you are looking on some sheets the results be displayed then you have to write a macro.
0