I have an excel sheet with a list of names in one column and some associated values in the next column. Some of these names appear several times with different values in the next column.
For example:
John AA
James AE
Trent TE
Jim CE
Trent AX
Jim XC
The result I'm looking to return from my vlookup function is:
John AA
James AE
Trent TE AX
Jim CE XC
Yet vlookup can only return one value, is there another function that can help me with this problem?