Return Cell References

[AdamDay]

Hello, this is my first time posting here. I've had a good search around for the same query and I can't find it. Can anyone help?

I am looking for a function in Excel that can search a range for a string in another worksheet and return the cell reference for that string when it's found.

i.e. if I am looking for the word "apple" in a worksheet and "apple" is in cell A2 then the function will return "A2".

I'm more than a little embarrassed that I've not worked this one out for myself!

Thanks in advance to anyone who can lend me hand.

[Dav]

Assuming apple is the only thin in the cell, so it does not say red apple for example try

=CELL("address",OFFSET(I2,MATCH("apple",I3:I8,0),0))

where the range of data is i3:i8

Regards

Dav