Hi All,

Need help on the following.

A V
1 AAA001 AAA001
2 AAA001 BBB001
3 AAA001 BBB002
4 BBB001
5 BBB001
6 BBB002

I need a formula in column V that could auto pick-up or
lookup what was inputed in column A and without repeating
in column V.

Thank you,
Kevin