VLOOKUP Tutorial: Updating prices in a master price list  MVP
Bill Jelen has created this VLOOKUP tutorial for those of you
who have a basic working knowledge of Excel but want to improve
your skills. This tutorial assumes you’ve heard about the
VLOOKUP function and its benefits, but that you don’t really
know how or when you might use it.  Bill uses the example of
updating prices in a product list to introduce the value of this
time-saving function.  The Problem: It’s taking way too long to
find and update prices in a master price list  The Solution:
Speed up the process with VLOOKUP    Suppose that you maintain
an Excel workbook with over 10,000 prices for products that your
company sells. Parts are arranged in sections by category. You
have part numbers in column A, prices in column B, and other
information in column C. Now, imagine that your manager just
gave you a worksheet with updates for 475 of the items in your
list.  Attempt 1: Use CTRL + F to update the list   You decide
to copy the price update to