vlookup that return the lookup value only once

[Ljung]

I have a table of item ordered that needs to be consolidated after they have been grouped.

The initial part is done where consolidation the qty and grouping according to postal code, now I am at the next phase of filling up the table with the remaining information.

I am trying to use vlookup, but this function only captures the first row in the list, example in this case, if more than 1 person having the same postal code, vlookup only return the first name in the list.
e.g. in this case, both peter and john is staying at the same postal code.
vlook_multiple1.JPG

How can I change the formula so that it will not repeat capturing the same information?
ie. in the above example with postal code 760125, after filling up 'john', excel to look for other entry than 'john' in subsequent cells and so forth.
vlook_multiple2.JPG

thank you in advance for your help.

[oeldere]

use index / match for that problem.

you can combine the name and postal code to make a indentifier unique.

[wenqq3]

= INDEX($Q$2:$Q$6,SMALL(IF("LOOK UP VALUE"=$P$2:$P$6,ROW($P$2:$P$6)-ROW($P$2)+1),1))

Ctrl + Shift + Enter

Something like this. Or please upload your sample file.