In a recent project, I have to work with a data file that has only 1,000 rows but 1,500 columns. When I need to compare the data between 2 similar documents, the first instinct is to use VLOOKUP. But I stopped immediately because I cannot imagine doing VLOOKUP for a range that is more than 1,500 columns wide and having to find out which column I am supposed to reference to. So for this case, I have to use the substitute for VLOOKUP, that is a combination of INDEX and MATCH formula. The results returned is the same as VLOOKUP but it is much faster in this case because I don’t have to count the columns and take up my computer resources to reference a range that is 1,500 columns wide.

Leave a Reply