Return Value Of Current Cell Position

  • Thread starter Thread starter win99ci
  • Start date Start date
W

win99ci

HELLO:

I WOULD LIKE EXCEL TO RETURN THE CURRENT POSTION OF A VALUE OF TH
SPECIFIC CELL.

E.G.

A B C
JAN 1
FEB 2
MAR 3

HOW CAN I RETURN THE CURRENT POSITION OF "JAN" IN COLUMN "C1"?

SUCH AS,
A B C
JAN 1 "A1"
FEB 2
MAR 3

HOPE THAT SOMEONE CAN HELP ME, THANKS
 
Hi
to return the row number (if your data starts in row 1) use
=MATCH("JAN",A1:A100,0)
 
You can also try the CELL function, for ex. ==CELL("address",A3) in cell C3
will return $A$3.

However, this sounds like strange thing to do... are you trying to use this
address in another function?

Robin
 
You can try this:

=ADDRESS(MATCH("JAN",A1:A5,0),MATCH("JAN",A1:B1,0),4)

It will return the "A1" that you requested.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


HELLO:

I WOULD LIKE EXCEL TO RETURN THE CURRENT POSTION OF A VALUE OF THE
SPECIFIC CELL.

E.G.

A B C
JAN 1
FEB 2
MAR 3

HOW CAN I RETURN THE CURRENT POSITION OF "JAN" IN COLUMN "C1"?

SUCH AS,
A B C
JAN 1 "A1"
FEB 2
MAR 3

HOPE THAT SOMEONE CAN HELP ME, THANKS!
 
Hi Win99ci

Since you know the address is in column A, all you need is the row
number. So:

="A"&MATCH("JAN",A:A,0)

If JAN appears more than once, this will return the cell of it's first
appearance.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top