CELL LOCATION!! SIMPLE QUESTION!!!!

H

HERNAN

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!!
 
R

Ron Coderre

Try this:

With
The word "house" anywhere in A1:E10

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

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

XL2002, WinXP
 
R

Ron Coderre

TYPO!

The correct formula for my posted example is:

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

(sorry about the error)
***********
Regards,
Ron

XL2002, WinXP
 
H

HERNAN

thank you so much, it works!

Ron Coderre said:
TYPO!

The correct formula for my posted example is:

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

(sorry about the error)
***********
Regards,
Ron

XL2002, WinXP
Click to expand...
 
Top