I have a database in the form of an Excel spreadsheet with a 'primary key' in COLUMN A. There are corresponding dates and shipment statuses, etc in the following columns. I would like to take vlookup and use it to find the matching 'primary key' or 'tracking number' in COLUMN A in another worksheet and bring the corresponding columns in the same row into the worksheet I am updating. Simple enough right? Except there are over 2000 rows to update. Is there a way to vlookup multiple rows in column A so that they update without running vlookups on each individual line? Basically I need to update shipment statuses and projected delivery dates.
Bookmarks