Hi Jack Sons,
maybe something like this...
=IF(SUMPRODUCT(--($A$1=B1:K1),(IF(B1:K1<$A$1,0,ROW(B1:K1))))=0,"", L1)
drag down formula
Mangesh
"Jack Sons" wrote in message
...
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