Forum Discussion
Find Cell Reference of a Value Within a Table
I'm looking to input a value in a cell and have a formula find the cell reference of that value within a table. Here is a screenshot to show what I mean.
Try this (Range being your data range or named item).
=REDUCE("",range,LAMBDA(a,v,IF(v=K2,ADDRESS(ROW(v),COLUMN(v),4),a)))