Vlookup Partial Matches HELP

[ramanm]

Hi All,

New user to the forum and require some assistance.

I am trying to find all partial matches for postcodes but not sure how this can be done:

Sheet 1:
Below are all the full postcodes

postcode1.PNG

Sheet 2:
Below are all the partial post codes I would like to try and match to sheet 1

partials.PNG

Also, there could be more than one full postcode match to a partial.

I would like search the rows and return all full post codes matches to partial ones. So I would get something like this:

MATCHES.PNG

Thanks in advance for any help.

[Pete_UK]

You've given us no information about the cells/columns that you use, so we can't give you a specific formula to try.

You can use the wildcard character ( * ) with VLOOKUP to look for a partial match, something like this:

=IFERROR(VLOOKUP(A1&"*",Sheet2!A:B,2,0),"")

Hope this helps.

Pete

[than_gold]

Try this partial vlookup formula:

Please Login or Register  to view this content.

https://exceljet.net/formula/partial-match-with-vlookup