I just want to know if any lookup value is repeating in range,which
function we should use at that time.
For ex

A B C
Name Value
a 2623
b 2561
c 12546
d 4563
a 452
c 223321
d 321

With above example i want to know how can we find each value for a in
lookup range A:A.
if is there any another nested function,please let me know

Regards
Ram