Get cell address of a defined cell in excel by excel formula -
if lets define cell "b6" name value_date how can cell address "b6" excel formula ?
if "define cell b6 value_date" mean create named range refers b6 , has range name "value_date", can use formula return address of named range:
=cell("address",value_date)
be aware if named range contains more 1 cell, formula return address of top left cell of range.
in screenshot below, cell c6 has formula per above.
edit after comment:
if range name stored text in cell, can use indirect() function evaluate cell text range.
=cell("address",indirect(a1))
to row of value_date via text in cell a1, use =row(indirect(a1))
Comments
Post a Comment