India Exam Junction
[Clerk (Evening) Dec, 2021]
13. What is the purpose of VLOOKUP function in MS-Excel?
It searches for character of 'V’
It finds the related records
It checks whether two cells have the same values
None of the above
Correct Answer :
It finds the related records
Solution
The VLOOKUP (Vertical Lookup) function in MS-Excel is used to search for a specific value in the first column of a table or range and return a value from another column in the same row. Essentially, it helps in finding related records based on a key value.
For example:
- If you have a table of employee IDs and names, you can use VLOOKUP to find the name corresponding to a particular employee ID.