This is a free Microsoft Excel Spreadsheet Tutorial. In this tutorial, I will show you how to use the VLOOKUP function in Excel.
The VLOOKUP function is useful for quickly finding information in complex spreadsheets. Use can think of the VLOOKUP function as a way to gather information based on specific data input.
In this tutorial, I will show you how to use the VLOOKUP function to pull information from row data based on criteria entered into a target cell.
I will also show you how to add a dropdown menu for the criteria cell to speed up selection.
Example VLOOKUP Function: =VLOOKUP(G1,A2:D5,2,FALSE)
See how my company can build an amazing website for your business
- Custom web design
- Secure and fast website solution
- Full management training
- Take control of your website
- SEO optimisation
- Reliable web hosting and emails
Video tutorial by: DCP Web Designers in London
