Excel VLookup vs Index and Match
I recently had a couple of queries about when to use Vlookup and when to use Index and Match in an Excel workbook.
I found the following links useful:
I remember reading somewhere that index and match were quicker than vlookup when large amounts of data and lots of recalculations were involved but I have not been able to find that reference again.
Categories: Excel
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Carl Sprake 