Avatar of Curly101

asked on 

Excel 2010: Copy content of cell, based on lookup in another worksheet

I have 2 files. Both have Item # column and Description column.

In file 1, I need to search in file 2 for the Item #. If it finds it, I need to copy the content of the Description cell in file 1 and paste in the the description cell in file 2.

I would like to be able to drag the cell down through the spreadsheet so that it fills in the rest of the rows.

Any help is appreciated!
Microsoft ExcelSpreadsheets

Avatar of undefined
Last Comment

8/22/2022 - Mon