I am using Excell 2003

I'm trying to set up an "IF" formula in one cell to to assign office
location to postcode located in another cell. for example
=IF(A1="BD*","Bradford","Leeds"
Where the * is a wildcard. The formula doesn't allow this however, as it
looks at only what is typed into the A1 cell. For a Bradford return I have
had to type BD* in A1. My aim is for an automatic listing of the appropriate
office once the post code is typed into the preceding cell. I may be going
about this the wrong way.

I would be grateful of any help