automatic fill

[vkuppa]

hi,

I HAVE 2 COLUMNS: 1) PART # AND 2)DESCRIPTION.

i WANT DESCRIPTION TO FILL AUTOMATICALLY IN COLUMN2 WHEN I ENTER PART # IN COLUMN 1.

I know this can happen by using IF statements could you please help me with this.

I have the data with part nos and descriptions in another sheet.

Looking forward for your reply.

Thanks,
Vishali.

[royUK]

You can use the CHOOSE Function or VLOOKUP - see this

http://www.excel-it.com/excel_functions.htm