Find Number from Table and return location (row and column)

[alexie0830]

I have a Table with Horizontal labels from 1 thru 100 and Vertical labels from 1 thru 100.

InnerTable has all these random numbers (10,000 numbers total). What i am looking for is return 2 values... 1 value for the Horizontal Label (Columns) and another value for Vertical Label (rows) ...

So essentially, if i am searching for number "53" .. It should return 8 and 7 (where 8= Column "I", and 7 equals row = 7).


=ADDRESS(SUMPRODUCT((tbl=53)*ROW(tbl)), SUMPRODUCT((tbl=53)*COLUMN(tbl)), 4)

This formula returns only one value (H4) ... I need for it to return 2 values into 2 different cells... H into 1 cell... and 4 into another cell..

Thanks

[NBVC]

This part should get you the row:

=SUMPRODUCT((tbl=53)*ROW(tbl))

and this the column

=SUMPRODUCT((tbl=53)*COLUMN(tbl))

Note: If you want the column letter, then try:

=SUBSTITUTE(ADDRESS(1,SUMPRODUCT((tbl=53)*COLUMN(tbl)),4),1,"")