VLOOKUP is used to extract data from a table based on a particular value that is being analyzed. VLOOKUP looks at a table in the first column for a specific value and returns a cell in the same row where you choose the column you want returned. VLOOKUP can be used for both text as well as numeric searches, which it a powerful function that can be used in your everyday tasks at work.