The Excel VLOOKUP formula lets you search for specific information in your spreadsheet. For example, if you have a list of products with prices, you could search for the price of a specific item.
We’re going to use the Excel VLOOKUP formula to find the stock quantity and colour of a specific item . You can probably already see this information as the data table in our example is a small set of data because this is a simple example.
Once you learn how to use VLOOKUP, you’ll be able to use it with larger, more complex spreadsheets, and that’s when it will become truly useful.
Once you have mastered the basics of the Excel VLOOKUP formula you can use it on more complicated spreadsheets to return multiple selection criteria.
For example, if you have a contact list you could search for someone’s name to find his or her phone number. If your contact list has columns for the email address or company name, you could search for those by simply changing the second and third arguments, as we show in our example. The possibilities are endless !