Try this:

With
The word "house" anywhere in A1:E10

Then
G1: house
H1:
=ADDRESS(SUMPRODUCT((A1:E10=G1)*ROW(A1:A10)),SUMPR ODUCT((A1:E10=G1)*COLUMN(A1:A10)))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"HERNAN" wrote:

I want to create a formula that tells me the cell location of x
ie: A
1 House

The formula would tell me then:

House = A1

It's this possible? thank you!!