function.:Lookup Problem

Dear All ...

I have a question on lookup function.
Please open the attachment file.
How can we tweak the lookup function to return the unique result from column "Name"?

Value Name
2 A
2 B
2 C
3 D
4 E
1 F

Thanks so much in advance.