Simple IF formula

Hi coders,

I am running a report weekly from SAP and saving it local, I would then like to open the generated report and insert a column "B" and add a simple template formula in B1 I can drag down 50 to 100 cells.

The formula I'm looking for would require the following,

If A1 = 2000 then B2 = Text Sydney
If A1 = 2010 then B2 = Text Newcastle
If A1 = 2020 then B2 = Text Wollongong
If A1 = 2030 then B2 = Text Wagga Wagga
If A1 = 2040 then B2 = Text Goulburn

Also I have around 15 different possible values that could appear in A1.

Please help

Thanks in advance.

Steve.