how to Enter a name by using ref. No.?

I

Imad Khanfar

Dear,

I need to know How can by entering only ref.# in a cell and in other cell
automaticly fill a name refered to this ref.#.
For example:
Ref.# Account Name.
13 Salary
14 George
15 Mike

So when I need to fill a cell with a Mike , no need to write the name the
only thing I do is write 15 so in the other cell automaticaly fills Mike

Please reply to me soon as possible you can.

Regards
Imad kh.
 
B

Bob Phillips

Look at VLOOKUP in help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top