What does the VLOOKUP function in Excel do?

Computer Mcqs for PPSC, FPSC, NTS, and Pakistan government job tests. Select an option below, then read the explanation.

PPSCFPSCNTSPakistan govt jobs
Subject
Computer Mcqscomputer-mcqs
Published
1 Jan 2023
Last updated
28 May 2026

Browse all Computer Mcqs

Choose the correct answer

Explanation

Option A is correct because VLOOKUP searches for a value in the first column of a range and returns a corresponding value from the same row. Option B describes HLOOKUP, while options C and D refer to SUM and AVERAGE functions respectively.

SolveExam — free MCQs and past papers for Pakistan government job tests. Content is for educational practice only.