Look at VLOOKUP in help.

--
HTH

Bob Phillips

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

"Imad Khanfar" <Imad wrote in message
...
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.