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?