- Jun 8, 2016
I got an excel sheet with 150,000 records. I need to match up each record with what we have on file in our online database. My job is to match the first 6 words in a cell to data in this online database. My job requires that I match each product in our inventory (in the spreadsheet) to products we have listed online. Doing this one by one takes forever, of course. How can I match the products in the spreadsheet to the products in our onine database rapidly without doing so one item at a time which takes forever??