How to use VLOOKUP function used in spreadsheet? Technical Solution | 2 min read VLOOKUP function can be used to extact relevant content from spreadsheets. Syntax: VLOOKUP(SearchCriterion; Array; Index; SortOrder). To understand the concept easily,consider the following example:-