Retrieve Cell refference of text

[Dave Breda]

Hey all EXCEL Guru's out there,

I'm trying to automate my excel formula's and i need to retrieve the cell refference of the first text string containing the text "Appels"

Spreadsheet is like:
A
1 Pear
2 Banana
3 Chimpansee
4 Computer
5 TV
6 HD flatscreen
7 Appels
8 HP Computer
9 LX Computer
10 Appels
11 Appels

etc etc

Text wil always be in 1 colomn.

Answer needs to be: row 7

All help is really apriciated!

Dave Breda

[Dave Breda]

Nobody, or am I asking the wrong answers?

[Fotis1991]

Do you mean?

=MATCH("Appels",A:A)

[Pete_UK]

Or maybe:

="A"&MATCH("Appels",A:A,0))

though you might have to change the commas to semicolons.

Hope this helps.

Pete

[Dave Breda]

Thanks Pete_UK worked like an angel!