I want to return the cell address of a cell containing a specific value.

eg. input a date and return the cell address where that date is found

Hi Larry

assuming that your dates are in B1:B200 and the date you're looking for is
in cell E1 the formula would be

=CELL("address",INDEX(B1:B200,MATCH(E1,B1:B200,0)) )

Cheers
JulieD

"Larry" wrote:

I want to return the cell address of a cell containing a specific value.

eg. input a date and return the cell address where that date is found

On the face of it ..

Suppose you have in A1:A3, the dates:
02-May-05, 03-May-05, 04-May-05

and you enter in B1: 03-May-05

Putting in say, C1: =ADDRESS(MATCH(B1,A:A,0),1,4)
will then return "A2", the cell in A1:A3 which contains the date matching
that input in B1

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Larry" wrote in message
...
I want to return the cell address of a cell containing a specific value.

eg. input a date and return the cell address where that date is found

can I locate the cell address with only the cell value. The only info I
would know is the column (eg. column A). I am trying to use this to locate a
range in another formula.

"Larry" wrote:

I want to return the cell address of a cell containing a specific value.

eg. input a date and return the cell address where that date is found

"Larry" wrote
can I locate the cell address with only the cell value.

But wasn't this was your original question for which you've already got 2
responses to try ?

The only info I would know is the column (eg. column A).
I am trying to use this to locate a range in another formula.

This is perhaps too vague for a meaningful response to be given.
One pointer that you seem to be hinting at is the use of INDIRECT. Try
providing more details on your set-up, some sample data, the expected
results, present formulas which you're using, etc, and I'm sure that you'd
receive better responses.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----