| CARVIEW |
Select Language
HTTP/2 200
content-type: text/html; charset=utf-8
date: Fri, 15 Aug 2025 10:10:02 GMT
permissions-policy: interest-cohort=()
strict-transport-security: max-age=31536000; includeSubDomains
server: nginx
cache-control: s-maxage=57686, max-age=0
x-powered-by: Next.js
etag: "5ul8t1g5tr8a1x"
content-encoding: gzip
x-xss-protection: 1; mode=block
x-content-type-options: nosniff
referrer-policy: no-referrer-when-downgrade
content-security-policy: default-src 'self' http: https: ws: wss: data: blob: 'unsafe-eval' 'unsafe-inline'; frame-ancestors 'self';
vary: Accept-Encoding
x-cache: Miss from cloudfront
via: 1.1 ccb35c1ed734caa3cfb4e5fdbeba1264.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM78-P9
x-amz-cf-id: AGOLgSgP2Tgamyc1Y84QJ6m2KhGistsi1Rr1O5ioosj_qmapdzlDCA==
Excel - Lookup Functions - INDEX and MATCH Combo 
- Courses
- Tutorials
- Practice
- Jobs
Data Structure
Java
Python
HTML
Interview Preparation
Interview Preparation
- Interview Preparation For Software Developers
- Must Coding Questions - Company-wise
- Must Do Coding Questions - Topic-wise
- Company-wise Practice Problems
- Company Preparation
- Competitive Programming
- Software Design-Patterns
- Company-wise Interview Experience
- Experienced - Interview Experiences
- Internship - Interview Experiences
Excel - Lookup Functions - INDEX and MATCH Combo
Last Updated :
Discuss
Comments
Why is INDEX with MATCH often preferred over VLOOKUP?
It can search both horizontally and vertically
It is faster than VLOOKUP
It doesn’t require the lookup column to be the first column
All of the above
This question is part of this quiz :
Excel Lookup & Text Functions QuizTags:
Share your thoughts in the comments
GeeksforGeeks
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy