Range Lookup - Problem
 

I would like to create vlookup to show all the leaders while keeping the
Client NR as the look up value.

Client Nr Client Nm Exec
Leader
103438 E D & F MAN COCOA INC Patrick T. Cahill (blank)
103438 E D & F MAN COCOA INC Patrick T. Cahill (blank)
103438 E D & F MAN COCOA INC Patrick T. Cahill (blank)
103438 E D & F MAN COCOA INC Patrick T. Cahill J.Moet
103438 E D & F MAN COCOA INC Patrick T. Cahill J.Moet
103438 E D & F MAN COCOA INC Patrick T. Cahill J.Moet
103438 E D & F MAN COCOA INC Patrick T. Cahill P. Lynder

The output should read as:

Client Nr Client Nm Exec
Leader Leader Leader
103438 E D & F MAN COCOA INC Patrick T. Cahill (blank) J.Moet
P. Lynder

Do you have any suggestion... I was just wondering if i need a "if" command.
Please advise