ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exel feature (https://www.excelbanter.com/excel-discussion-misc-queries/246555-exel-feature.html)

confused&lost

Exel feature
 
In Excel 2005, can a document be made that when you enter a number in one
cell a a description will fill-in on the same line for that particular
number which was entered in?

Jacob Skaria

Exel feature
 
If you are looking at converting to words check out the below link

http://support.microsoft.com/kb/213360

If this post helps click Yes
---------------
Jacob Skaria


"confused&lost" wrote:

In Excel 2005, can a document be made that when you enter a number in one
cell a a description will fill-in on the same line for that particular
number which was entered in?


Niek Otten

Exel feature
 
But if you need a descrition to show like a part name, llok at the VLOOKUP()
function.

See this tutorial:
http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Jacob Skaria" wrote in message
...
If you are looking at converting to words check out the below link

http://support.microsoft.com/kb/213360

If this post helps click Yes
---------------
Jacob Skaria


"confused&lost" wrote:

In Excel 2005, can a document be made that when you enter a number in one
cell a a description will fill-in on the same line for that particular
number which was entered in?



Gord Dibben

Exel feature
 
See VLOOKUP in Excel help.

Or better than help see Debra Dalgleish's site.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 07:51:01 -0700, confused&lost
wrote:

In Excel 2005, can a document be made that when you enter a number in one
cell a a description will fill-in on the same line for that particular
number which was entered in?




All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com