View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Imad Khanfar Imad Khanfar is offline
external usenet poster
 
Posts: 1
Default how to Enter a name by using ref. No.?

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.