Peter Simsa
Posted on:

04 Jan 2022
0

vlookup vs index/match...

in Introduction to Excel / INDEX, MATCH, and Their Combination - The Perfect Substitute for VLOOKUP

hi,
the match column can be anywhere not only in flank position.
also Vlookup doesnt need to be the first column, the limitation is that it can only search to the left of its position.



happy new year :)

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Aniruddha Chourasia
0
20
TRUE and FALSE argument in Vlookup!
Mario Contreras
1
12
Why are we using SUMIF to transfer data instead of using VLOOKUP?
Panagiotis Blatsas
0
12
Index and Match exercise tried the exact formula yet all results are N/A?
Manoj Bhaskar Pammi
0
12
Resolved: Doubt regarding Match and Index combined.
Rajesh Ravanappan
2
4
Resolved: Error in Explanation in VlookUp
Nighat Iqbal
0
4
Resolved: Vlookup error when switching sheets
Fatima Alzhra Buny
0
2
VLOOKUP function
Dylan Ritter
0
2
Resolved: Why use Index Match when you can just use Index?
Kerry Seymour
0
2
Error in formula code for exercise 50 (using index and match together)
Naseeba
1
2
Why isnt INDEX and MATCH used?
Siddharth Dwivedi
0
2
Can we always use Index and Match combination in place of Vlookup and Hlookup?
Nita
0
0
Error message in Vlookup