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.