Hello everybody,

I have 2 columns Part # and its Description. I am creating BOM lists and I want the description to be automatically appear into its column when I type in the Part #. I have the data of Part #'s with their description in other spreadsheet.

Looking forward for help.

Please respond.

Thanks,
Vishali.