ST Alpha - "I have switched almost 100% to INDEX, MATCH because it's faster (returns a range, not a value)." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 158

In response to "I would use a vlookup with an iserror to correct for ones not in Tab 2." by spamlet

I have switched almost 100% to INDEX, MATCH because it's faster (returns a range, not a value).

Posted by peggy ann m (aka amanda) Jul 1 '14, 08:19

I only use vlookup or hlookup now when I am doing something quick and dirty (yes, I just said quick and dirty).

Responses:

Post a message top