The best way to make lookups faster is by avoiding them. But whenever I am building a complex report or model with thousands of lookups, I try to use INDEX+MATCH formulas. I prefer to use VLOOKUP for simple situations as it is easy to write. Why not just use INDEX+MATCH all the time? when performing multiple lookups (usually thousands or more).Looking up anywhere in data (not just in the left).It is easy to use and works as long as you are looking up on the left and returning values from right. Let’s say you just need to lookup details for someone or something out of a any sized data-set. VLOOKUP is a good option when you have simple data or lookup situations. =INDEX(Sales, MATCH(“Jessy”, Sales, 0)).To answer above questions, you can use below INDEX+MATCH formulas. INDEX+MATCH combination formula helps you answer same questions as VLOOKUP, but they also allow you to answer questions about data from anywhere ( not just the left most column).įor example, you can answer questions like: To answer above questions, we can use below formulas: How many customers did “ Jonathan” have?.You can use VLOOKUP to answer questions like, Given some data, you can use VLOOKUP to answer questions about it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |