thank you so much, it works!

"Ron Coderre" wrote:

TYPO!

The correct formula for my posted example is:

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

(sorry about the error)
***********
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!!