ExcelBanter - Cell Reference

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cell Reference (https://www.excelbanter.com/excel-worksheet-functions/149272-cell-reference.html)

Luke

Cell Reference

Hi,
Is there a function or formula i can use to look up a value and then display
the cell reference ie C4?
Many thanks
Luke

Cell Reference

if I read what you want correctly
try
=address(index(range,match(criteria,match,0)))
will give the cell address

"Luke" wrote:

Hi,
Is there a function or formula i can use to look up a value and then display
the cell reference ie C4?
Many thanks
Luke

Luke

Cell Reference

Great, thanks BJ

"bj" wrote:

if I read what you want correctly
try
=address(index(range,match(criteria,match,0)))
will give the cell address

"Luke" wrote:

Hi,
Is there a function or formula i can use to look up a value and then display
the cell reference ie C4?
Many thanks
Luke

All times are GMT +1. The time now is 12:21 PM.