Can we always use Index and Match combination in place of Vlookup and Hlookup?

Question

Can we always use Index and Match combination in place of Vlookup and Hlookup? I mean, can they be applied in every situation?

Answer 1

Hi Siddharth,
Absolutely, we can do that. Highly recommended to do it actually. The only drawback is in situations when your work file becomes too heavy. In those cases, VLOOKUP might be preferable as it is 'lighter' for the machine.
Best,
Ned

Can we always use Index and Match combination in place of Vlookup and Hlookup?

Submit an answer

related questions