Assuming Table Range is A1:E10 with numbers and need to search for a number, in this case ‘2’, then enter this Array Formula** to get the Row and Column number.
{=MIN(IF(A1:E10=2,ROW(A1:E10)))}
{=MIN(IF(A1:E10=2,COLUMN(A1:E10)))}
Assuming Table Range is A1:E10 with numbers and need to search for a number, in this case ‘2’, then enter this Array Formula** to get the Row and Column number.
{=MIN(IF(A1:E10=2,ROW(A1:E10)))}
{=MIN(IF(A1:E10=2,COLUMN(A1:E10)))}