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.
Perhaps this (Ctrl_Shift_Enter):
=ADDRESS(SMALL(IF(range=K2,ROW(range)),1),SMALL(IF(range=K2,COLUMN(range)),1),4)