Computer · MS Excel
What is the primary function of the VLOOKUP function in MS-Excel?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1Calculates the total number of vertical cells containing data
- 2Searches for a value in the first column of a table array and returns a value in the same row from another column✓
- 3Checks whether the text is the same in one cell as in the next
- 4Looks up text that contains the letter 'v'
Correct answer
Searches for a value in the first column of a table array and returns a value in the same row from another column
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Preparing for Computer?
Practice full-length Computer mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice MS Excel MCQs →Want more practice questions on MS Excel?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer · MS Excel