Finding a string in a column, and returning it's position..

Avatar

Board Regular
Joined
Sep 20, 2005
Messages
193
Greetings all,

Basically i'm looking for a way to find a string in a column and return it's row number. Sounds mega simple to me, but i'll be damned if i can figure this one out..

I can't use code on this one though.
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,760
Office Version
  1. 365
Platform
  1. Windows
Try:

As long as your column starts in A1, otherwise you'll have to put a bit of simple maths on the end:

=MATCH("*yourstring*",A1:A100,0)

...... retain both the " and the *
 

Watch MrExcel Video

Forum statistics

Threads
1,118,824
Messages
5,574,525
Members
412,601
Latest member
TheBeaniacExpress
Top