Multiple choice technology

What does the VLOOKUP function do?

  1. Looks up text that contains "v".

  2. Checks whether text is the same in one cell as in the next.

  3. Finds related records.

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

VLOOKUP searches vertically down the first column of a table and retrieves a value from a specified column in the same row. It's commonly used to find related records like looking up a product ID to get its price, or finding employee details based on an employee number. The 'V' stands for 'vertical' as opposed to HLOOKUP which searches horizontally.

Keep practicing — related questions