Assume your data (text or numbers) is in column A from A1 to A30. Use
cell C1 to enter the value you are searching for. Enter this formula in
B2:

=MATCH(C$1,A$1:A30,0)

and in B2:

=MATCH(C$1,INDIRECT("A"&(1+B1)&":A30"),0)+B1

then copy this one down for a few cells, say to row 9.

This will return the row that each item specified in C1 appears and
#N/A when the list is exhausted - no error checking built in. You can
add the following in cell D1:

="A"&B1

to get the cell address.

Hope this helps.

Pete