generating automated names to numbers

Hello,

Which formula helpes me to determine a name to a number.

Example

in column A you can choose a number from 1-10

I want that at that moment in column B the name that is linked to that number apears

1: Canteen
2: Lockers
3: offices
4: meeting room

I have already created 2 columns for this but now i still need the formula.

Can Anyone help me

Thanks in advance.

Kind Regards

numers to name.xls

Is this a solution good enough??

-Rich-

Kind Regards for the quick and helpfull reply

You really helped me.

Thanks a lot