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...
Get a quote
- We offer a price match guarantee.
- Set-up is simple, with a fully branded LMS, single sign-on and API integration.
- It works on desktop and mobile, so your team can train wherever suits them.
Once you’ve sent your details, one of our team will be in touch to talk you through your training options.