Discussion
In MS Excel, the VLOOKUP function is used to
Answer: A
Correct answer: find a value in the first column of a range and return a value from another column of the same row
VLOOKUP searches for a value down the first column of a range and returns a value from a specified column of the matching row. Its arguments are the lookup value, the table range, the column index number, and a final argument for the match type. The final argument is where most errors arise. FALSE demands an exact match; TRUE, which is the default if omitted, finds the nearest match below and requires the first column to be sorted. Leaving it out on unsorted data returns wrong answers silently rather than an error, which makes it a dangerous default. Two structural limitations are worth knowing: it can only look rightwards from the first column, and the column index breaks if a column is inserted into the table. HLOOKUP does the same across a row. INDEX with MATCH, and the newer XLOOKUP, avoid both limitations and are now generally preferred.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development