What is the purpose of the VLOOKUP function in Excel 2007? The VLOOKUP if a "vertical" lookup formula that: needs to know what number you want to look up, where to look it up like a table or range so it can compare with an equal or greater than value, and then to return that comparative value from a column you specify. In short, the VLOOKUP is typically used to lookup things like numbers in huge spreadsheets and make comparisons to return the value desired! You can see this in action for yourself and the practical application the VLOOKUP function is most used for things like figuring out your taxes, looking up an inventory number to return the exact number and so on...

Purchase the training video and you can see this in action for yourself!