a simple question: the reference of a cell
a simple question: the reference of a cell
(OP)
I am not very good with excel... Looking for a command that would search for a given value in a column and return a reference (in a form C32 for. eg.) of the cell that value is in.
How can i do that?
How can i do that?





RE: a simple question: the reference of a cell
=ADDRESS(MATCH(3,D:D)+1,4)
=====================================
(2B)+(2B)' ?
RE: a simple question: the reference of a cell
=ADDRESS(MATCH(3,D:D)+1,COLUMN(D:D))
=====================================
(2B)+(2B)' ?
RE: a simple question: the reference of a cell
Final answer (to find address containing "3" within column D:
=ADDRESS(MATCH(3,D:D),COLUMN(D:D))
=====================================
(2B)+(2B)' ?
RE: a simple question: the reference of a cell
RE: a simple question: the reference of a cell
But now why this does not work:
If:
=ADDRESS(Match(32,A:A),1,4,TRUE)
returns the 'A13'
and
=Offset(A13,1,0,1,1)
returns the value of the cell A14,
why does
=Offset(ADDRESS(Match(32,A:A),1,4,TRUE),1,0,1,1)
does not return the value of the cell A14???
RE: a simple question: the reference of a cell
=OFFSET(INDIRECT(ADDRESS(MATCH(32,A:A),1,4,TRUE)),1,0,1,1)
=====================================
(2B)+(2B)' ?
RE: a simple question: the reference of a cell
RE: a simple question: the reference of a cell