I have a Master List of 30,000 Item #'s in one sheet. Each Item # has a corresponding Description, UPC, Price, etc. From time to time, I'll get a list of say 500 Items #'s where I need to update the Descriptions, UPC's and Prices. If I VLOOKUP the 2nd list into the Master, I'll get #N/A for the 29,500 not on the 2nd list.

Is there a function or process that will allow me to only update the items found in the 2nd list?

Currently, my workaround is creating a 2nd column for each category, performing a VLOOKUP, deleting out #N/A's, and manually copying and pasting each individual cell that contains a value. This can't be the best way, right!?