Word search in Excel

Closed
Nate - 6 Jun 2011 à 09:11
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Jun 2011 à 13:40
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
6 Jun 2011 à 13:40
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.