Postcode Search

[philb99]

Hi - I have a member database >1000 in excel and wish to know how I can search for a number of different Postcodes for example B1, B23, CF16, DY9, DY16 SL5, AR6 and produce in a list, the name of the member and the Postcode.

Member Name is in Column F and Postcode in in Col K

With UK postcodes they can either start with one letter or two for example B1 or DY10 and the numbers could range from 1 to 99.

Dropbox

www.dropbox.com

 

[Logit]

You could create a filter that only displays the requested postal code. The entire row will be shown. From there you can copy only the visible rows
and transfer that data to a separate worksheet (if this is desired).

Sound like a solution ?

 

[Peter_SSs]

Many of the helpers here choose not to download files from other sites or, due to security restrictions at their workplace, are unable to download such files. You will generally get faster responses if you provide you small sample data directly in your post with XL2BB
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

Is this the sort of thing you are after?

philb.xlsm
	F					K									T	U	V	W
1
2	Name					Post Code										Postcodes of Interest	Name	Post Code
3	Tony Evans					B1 4XB										B1	Tony Evans	B1 4XB
4	Steve Brown					B29 5RF										B23	Paul Willis	DY13 4RF
5	Paul Willis					DY13 4RF										CF16
6	John Stone					DY1 5TH										DY9
7																DY13
8																SL5
9																AR6
10
11
Sheet1

Cell Formulas
Range	Formula
V3:V11	V3	=IFERROR(INDEX(F:F,AGGREGATE(15,6,ROW(F$3:F$11)/ISNUMBER(MATCH(LEFT(K$3:K$11,FIND(" ",K$3:K$11)),U$3:U$9&" ",0)),ROWS(V$3:V3))),"")
W3:W11	W3	=IF(V3="","",VLOOKUP(V3,F$3:K$11,6,0))

 

[philb99]

Brilliant - thank you

Peter_SSs​

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.