Return row or column of a cell within a range

[The Phil]

With the list that I generate (from another thread), I now need to search for the result in the original data and return the column and row separately. (I need to nest this in some larger formulas which I already have figured out.) I attached a simple example with highlights. Basically, search for B2 in Data!$B$8:$AF$29 and return the column it is found in. The extra tricky part is that if there is more than one occurence in column B then it searches for the next occurence of that number. On the example sheet 165.65 occurs twice (which I highlighted), so the first search would give the row/column for the first occurence and the second formula would figure out it is the second one and return the row/column of the second occurence in the data range.

I've tried combinations of CELL, MATCH, ADDRESS etc but to no avail.

Thanks.

[DonkeyOte]

Why not just reverse the logic and use the second approach illustrated on your prior thread... that is to say return the "address" in A and use that value to determine values to be retrieved.
The values returned in A2 onwards represent the various positions of each value within the grid (COLUMN.ROW)

[contaminated]

Actually don't know what u did in your prior thread but to find rownum u can use this function

=SMALL(IF(B68=Data!$B$8:$AF$29,ROW(Data!$B$8:$AF$29)),COUNTIF($B$2:B68,B68))

To Find ColNum this one
=SMALL(IF(B2=Data!$B$8:$AF$29,COLUMN(Data!$B$8:$AF$29)),COUNTIF($B$2:B2,B2))

Both are confirmed with ctrl+shift+enter and copied down as far as needed...

[The Phil]

Thanks guys, got it working just like I needed!!!