Converting number into predefined text

[Solidsteel]

Ex.:

Mr. Davis is number 1111
Mr. Jones is number 2222
Mr. Edison is number 3333

A1=1111
A2=2222
A3=3333

B1=Mr. Davis
B2=Mr. Jones
B3= Mr. Edison

I need the following:

Cell no. 1 : Here I want to type the number of the person
Cell nr. 2: Here I want Excel automatically to write the name of the person corresponding to the number I typed in cell no. 1.

Help is much appreciated.

How is this done?

[daddylonglegs]

You can use VLOOKUP

type the number in D2 then in E2 you can use this formula

=VLOOKUP(D2,A$1:B$3,2,0)

[Solidsteel]

Have you tried this yourself - I cannot get it to work

[daddylonglegs]

See the attached, I used the suggested formula in E2 and copied down to E4 to get further results for the numbers in D3 and D4

Edit: Note that for European (non UK) versions of Excel you may need to replace commas with semi-colons so formula might be

=VLOOKUP(D2;A$1:B$3;2;0)

If you open my attachment that conversion should happen automatically, I think (I used commas as per my version above)

[Solidsteel]

Fantastic! Works now. The semi-colons did it ;o)

Thank you very much for assisting!

[kristiqn]

Thank you very much. This is working great. The think that I was trying ti make is to change/replace text with predefined number, stored in another sheet. Works like a charm.