My spreadsheets bot have the following rows: Dept. Description Merch. Cat. Description Taxware Product Code One spreadsheet has the several columns of company information and the other needs to have the items matched with the correct Dept. Descrp, Merch. Cat Descrp, and Tax Product code. However, I do not want to copy of paste the information by each new line on the new spreadsheet. How would I consolidate the two having the spreadsheet with the complete information carry over the information to the matching product on the new spreadsheet? Not every column will be listed in the new spreadsheet, so a search for like items will need to be conducted?