=IF(LEFT(A1,2)="BD","Bradford","Leeds")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tobias" wrote in message
...
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