| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Range Lookup | Excel Discussion (Misc queries) | |||
| Lookup from a range on separate sheets | Excel Discussion (Misc queries) | |||
| Lookup Problem | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
