ExcelBanter - CELL LOCATION!! SIMPLE QUESTION!!!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CELL LOCATION!! SIMPLE QUESTION!!!! (https://www.excelbanter.com/excel-discussion-misc-queries/114944-cell-location-simple-question.html)

HERNAN

CELL LOCATION!! SIMPLE QUESTION!!!!

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

Ron Coderre

CELL LOCATION!! SIMPLE QUESTION!!!!

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

Ron Coderre

CELL LOCATION!! SIMPLE QUESTION!!!!

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

HERNAN

CELL LOCATION!! SIMPLE QUESTION!!!!

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

All times are GMT +1. The time now is 11:10 AM.