If that’s the problem, now is the time to point them in the right direction. Second, you might be working with Excel beginners who sort of understand VLOOKUP but who know nothing about INDEX-MATCH. If that’s the problem, I hope this post will help. I can think of only two reasons you ever should use VLOOKUP (or HLOOKUP, which does the same thing, but sideways). First, you might not know how to use INDEX-MATCH. At its worst, INDEX-MATCH is slightly faster than VLOOKUP at its best, INDEX-MATCH is many-times faster. INDEX-MATCH is much more flexible than Excel’s “lookup” functions.Ģ. Excel’s VLOOKUP function is more popular than the INDEX-MATCH function combination, probably because when Excel users need to look up data then a “lookup” function would be a reasonable choice to make.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |