Q. What does the VLOOKUP function do?

A
Sorts data
B
Finds and retrieves data from a table
C
Counts unique values
D
Filters data
Solution:

VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!