Staff Skills academy+
Home » Courses » Microsoft Excel for Beginners Certification » Module 17 : VLOOKUP
Module 17 : VLOOKUP
17.1 VLOOKUP in ExcelThe VLOOKUP function is one of the reference and lookup functions in Excel, and it helps you to find specific data in a table or in a specific range by row of data.For example, the VLOOKUP function is useful if you want to look up an inventory item by inventory number.The way to input the function is the following:=VLOOKUP(value, table, col_index, [range_lookup])Value: the value to look for.Table: the table from which to retrieve a value Col_index: The column in the table fr...
Lessons
- Module 1 : Introduction to Excel
- Module 2 : Add
- Module 3 : Multiply
- Module 4 : Subtraction in Excel
- Module 5 : Dividing
- Module 6 : Sort
- Module 7 : Percentage
- Module 8 : Running Totals
- Module 9 : Print
- Module 10 : Paste Special
- Module 11 : Merge
- Module 12 : Filter
- Module 13 : AVERAGE
- Module 14 : AVERAGEIF
- Module 15 : SUMIF Formula
- Module 16 : IF Formula
- Module 17 : VLOOKUP
- Module 18 : HLOOKUP
- Module 19 : COUNTIF Formula
- Module 20 : COUNTBLANK
- Module 21 : COUNTA Formula
- Module 22 : COUNT Formula
- Module 23 : CONCATENATE
- Module 24 : TRANSPOSE
- Module 25 : DATE Formula
- Module 26 : MONTH Formula
- Module 27 : Pivot Tables
- Module 28 : Pie Charts
- Module 29 : Doughnut Charts
- Module 30 : Line Charts
- Module 31 : Column Charts
- Module 32 : Bar Charts
- Module 33 : Number Formatting
- Module 34 : Create Borders
- Module 35 : Conditional Formatting
- Module 36: Comments
