Thread: match value in one column to adjacent value: use vlookup or index/match?

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

You tried?

=VLOOKUP(C2,A:B,2,0)