Finding the location of a string or value

[sdurber]

Is there a function that will return the location of a text string within a worksheet?

For example.

If I have a list of months - January to December in "coloumn A" and searched for March. The result of my function would be the position "A3"

[Qroozn]

are you doing the search via VBA?
Do you want to type the "string" you are looking for in a cell and have the "location, returned?
or do you want to use the Edit/Find



[ This Message was edited by: Qroozn on 2002-04-30 21:41 ]

[sdurber]

I have a list of strings (months) that will be searched for. So effect it will be typed.

My project is this

I have a list of months and hours worked by the side of each month in the next coloumn.
I want to be able to select a start and stop date (month) and then be able to sum the hours worked during that period.

[ This Message was edited by: sdurber on 2002-04-30 21:46 ]

[Yogi Anand]

On 2002-04-30 21:36, sdurber wrote:
Is there a function that will return the location of a text string within a worksheet?

For example.

If I have a list of months - January to December in "coloumn A" and searched for March. The result of my function would be the position "A3"

for the formula approach use

=ADDRESS(MATCH(C1,A1:A12),COLUMN(A:A),4,1,)
if your data is housed in cells A1:A12, and C1 houses March, the formula will result in A3

Hope This Helps!

[sdurber]

Thanks very much for the suggestions guys.
It worked a treat.