In Excel, what does the VLOOKUP function do$?$

Written Guidance:

Remember the primary purpose of the VLOOKUP function in Excel is to find a piece of data in a table based on some lookup value. The function then returns a related piece of information from a different column but the same row.

No answer text provided.

It searches for a phrase in the first column of a table array and returns a value in the same number from another column.

It searches for a value in the first column of a table array and returns a value in the same column from another column.

It searches for a value in the first column of a table array and returns a value in the same row from another column