I know how to apply each technique: INDEX/MATCH vs. VLOOKUP (or HLOOKUP).
Instead of focusing on personal preferences, I'm more interested in the following contrasts between them:
Is there something that one method can do that the other cannot?
Which one is more efficient in general (or does it depend on the situation)?
Are any other advantages/disadvantages to using one method vs. the other
Can someone please help me with this?