cell addresses

L

Larry

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
 
J

JulieD

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
 
M

Max

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
 
L

Larry

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.
 
M

Max

Larry said:
can I locate the cell address with only the cell value.
Click to expand...

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.
Click to expand...

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.
 
Top