Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to Enter a name by using ref. No.?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
how to enter numbers value for calculation? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
"Enter" in Macros | Excel Discussion (Misc queries) | |||
Enter last name, auto fill full name & address--HOW? | Excel Discussion (Misc queries) |