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!