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