match string to values in worksheet range

[Chris Baluyot]

Hi guys, is there a quick way without doing a loop to match a string value into a range in worksheet, lets say i have a string "activenote" and I want to match this to values in column a of sheet1. I would like to extract the row number where the match is found.

Thanks in advance...

[rylo]

Hi

Use the

Please Login or Register  to view this content.

approach. This will return the position in the range if it appears.

rylo

[Trebor76]

Hi there,

You can use the following formula which I adapted from this posting:

=ROW(INDIRECT(ADDRESS(MATCH("activenote",A:A,0),COLUMN(),1)))

HTH

Robert

[Chris Baluyot]

Thank you very much you all !.
i'll give that a try.