Special searches

[Blower]

I'll try to be specific -

I have a situation at work whereby I need to enter the start of
postcode/zip code - and it returns which field worker covers tha
area.

What I have to work with is something that looks like this

Mr.A - All S postcodes
Mr.B - B1-14 (B1, B2, B14 etc)
Mr.C - C2, 7, 9, 10
Mr.D - C1, 3, 8, 11

A simple search has lots of problems - to search "C" only would retur
mr C + mr D.
Another problem is if i was to search B2 Mr.B would not show as the ra
data says "B1-14" not "B1, B2, B3" etc.

I appologise for my lack of knowledge since im basically asking you t
do the work for me - but im not sure how else to gain this knowledge
my excel for dummies wasn't much help.
Can I use wildcards in a search? anything to cut the absolutness of th
find function...

My goal will to be have one sheet with all the confusing and mas
amounts of data on one sheet - and a front sheet simply asking for th
entry of 2 postcode characters - a cell below will return the fiel
workers name.

I appreciate any info - even good links to newbie guides to this sor
of thing would help alot. Just ask if you need more specific info o
what my goals and source is, however I can't provide the data itsel
because its real (data protection crap)

Thanks in advanc

 

[Bill Kuunders]

you will have to organise your list of post-codes and post men first.
then you can use the vlookup function on sheet1
something like
=VLOOKUP(A1,Sheet2!A1:B50,2,FALSE) in B1 on sheet1
where A1 is the cell on sheet 1 where you enter the post code
sheet2!A1:B50 is the list of codes and names
2 is indicating that you want to look up a value in the second
column
false is indicating that you want an exact result.

regards
Bill K