Mangesh,

Your solution

=INDEX(L1:L10,SUMPRODUCT(--($A$1=B1:K10),(IF(B1:K10<$A$1,0,ROW(B1:K10)))))

works fine, but only if the numbers in the matrix occur not more than once.

Is it possible to return a list {.......} of all values of L1 to L10 (or -
preferably - in a column by copying the formula down) corresponding to the
rows in which the reference value (in this case the 123 in A1) occurs,
allowing for more than one occurence per row and also allowing for more than
one per column?

Jack Sons
The Netherlands




"Mangesh Yadav" schreef in bericht
...
check this thread. Is this what you want...?

http://excelforum.com/showthread.php?t=369480

- Mangesh


"David" wrote in message
...
Greetings and TIA for your time.
Is there any way of returning the (row, column) position of a value from
a
2
dimensional array.
--
David