Hello,
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!
Thanks,
Conor
Bookmarks