Vlookup with multiple occurances of a value

[Hyp40]

Hi. I have a master postcode list and have been using Vlookup to check if my postcode is in the master list and to bring back info from neighbouring cells in the master postcode list. This was working well until I found that my postcode could occur more than once in the master list (with different info in the neighbouring cells). How can I get each of these back rather than just the first one? Also, some cells in the master list contain a number of postcodes, separated by commas. The vlookup doesn't find any of these. The master list changes weekly, so it is impractical to separate out the cells with multiple postcodes in.

 

[Hyp40]

Hi again Fluff. I promise this will be my last question!
If I wanted to get different/more columns from the Master list - what would I need to change to give me the different column(s)?

 

[Fluff]

You'd need to change the parts in blue

            If Not .Exists(Trim(Sp(i))) Then
               .Add Sp(i), [COLOR=#0000ff]Cl.Offset(, 1).Resize(, 3)[/COLOR]
            Else
               Set .Item(Trim(Sp(i))) = Union(.Item(Trim(Sp(i))), [COLOR=#0000ff]Cl.Offset(, 1).Resize(, 3)[/COLOR])
            End If

So if you wanted to get columns C:F you'd use

Cl.Offset(, 2).Resize(, 4)

 

[Hyp40]

Thank you sooooooo much. And such an incredibly fast response time.

 

[Fluff]

You're welcome & thanks for the feedback