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. |
All times are GMT +1. The time now is 07:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com