match value in one column to adjacent value: use vlookup or index/match?
I have a spreadsheet (sample attached) with four columns. One is a long list of client names, and in the adjacent column is a list of their corresponding firms. In the third column I have a list of unique client names (since the client list has many repeats). I would like the fourth column to display the firms that correspond to the unique client names.
I have tried fiddling around with VLOOKUP and INDEX and MATCH functions, but to no avail.
Any advice would be much appreciated!
Last edited by conorsgaffney; 09-28-2010 at 05:00 PM.