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? |
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? |
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? |
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