Index/Match or VLookup returning Multiple Results

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:

Please Login or Register  to view this content.

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.

Hi there, yes excel can do that but its difficult without seeing the workbook, try to upload your sample file here, click "Go Advanced" button and find Paperclip Button to attach your file.


Cheers

Hi Azumi,

Attached as requested - many thanks.

Not clear about your expected results, would you give the example in your sample workbook?