Formula equivalent to ctrl+F?

[AbrahamGluck]

[FONT=&quot]<form action="https://www.reddit.com/r/excel/comments/29qsxs/formula_equivalent_to_ctrlf/#" class="usertext warn-on-unload" id="form-t3_29qsxsoki" style="margin: 0px; padding: 0px; font-size: small;">I need help trying to figure out a formula equivalent to ctrl+F. (or using VBA)
I need the formula to take text and search the entire sheet for any cell which contains the text. (not vlookup, since the text is not word-for-word)
Example: search entire sheet for the word: “Test” Return a cell which contains text: “Reddit Is Awesome, Test” Same as if you did: find – “Test”




</form>[/FONT]

 

[Scott Huish]

Sub findit()
Dim x As Range
Set x = Cells.Find(InputBox("Find Text"))
If Not x Is Nothing Then x.Select
End Sub

 

[AbrahamGluck]

Sub findit()
Dim x As Range
Set x = Cells.Find(InputBox("Find Text"))
If Not x Is Nothing Then x.Select
End Sub

Any formula please, a formula will be more user friendly for me

 

[Scott Huish]

You had said or using VBA, but you can check for it in a column or row with a formula, I don't know about the whole sheet.

Excel 2010
	A	B	C	D
1		Search Word:	test	Reddit Is Awesome, Test
2
3
4
5
6
7
8
9
10
11
12
13
14
15	Reddit Is Awesome, Test
16
17
18
19
20
Sheet1

Cell Formulas
Range	Formula
D1	=INDEX(A:A,MATCH("*"&C1&"*",A:A,0))