The VLOOKUP function is a handy one to know when you want Excel to
lookup a value in one place and insert it in another. For example,
let’s say you have a list of all of your customers on a sheet named
“Accounts” and an invoice on another sheet named “Invoice”. When you
type in their account number on the Invoice, you want Excel to fill in
the name of the customer and their address (and this information is
included for all customers on the Accounts sheet). A VLOOKUP will do
this for you.
Here's a tutorial that will help:
http://www.timeatlas.com/mos/5_Minute_Tips/General/Learning_VLOOKUP_in_Excel/
358 views
Usually answered in minutes!
×