Hi all,

I have seen a few posts about this already but can't seem to figure out where I am going wrong in implementing a formula to return multiple results with an INDEX/MATCH or VLOOKUP.

I have a large list of data that has a unique reference number. The problem arises is that there are two lines for some of these reference numbers, which return a different result. I've posted a sample piece of data below:
Reference Number	Linked Account	Linked Account 2
1234	                   1111	                     1111
1234	                   2222	                     2222
4321	                   3333	                     3333
4321	                   4444	                     4444
9876	                   5555	                     7777
7654	                   6666	                     8888

The linked account is returning the same in both the first and second instance, which should not be the case (to do with some data exporting from a third party source...)

Ideally, I want to be able to display the data in one row, so that 'Linked Account' shows the first unique account number, and 'Linked Account 2' shows the second unique account number.

NB. Due to the nature of the accounts, there will only ever be two matches.

However, as with the bottom two references (9876 and 7654), these are already set up correctly in some instances and do not require any action.

Can anyone think of a solution? Apologies if this seems poorly explained - can provide more detail if needed.