Look up one value and return multiple corresponding values
I think that this is array formula is all that you need to get the name that
is in C2
=IF(ISERROR(SMALL(IF($A$1:$A$100=$C$2,ROW($A$1:$A$ 100),""),ROW(A1))),"",
INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=$C$2,ROW($A $1:$A$100),""),ROW(A1)),0))
--
__________________________________
HTH
Bob
"Sandeep Jangra" wrote in message
...
D'all,
I have a two column (Name and Amount) list with repeated values, Plz help
me
about these ...
1. I want to look up all the repeated values against a single name
2. lookup heightest and lowest amount against a single name.
Sandeep Jangra
|