democratizing data and analytics
Although VLOOKUP in Excel is a very useful function, it suffers a drawback. If the lookup value to be searched is not in the first column of lookup table, VLOOKUP wouldn’t work. In the last part of this learning series, titled "VLOOKUP: Right to Left Lookup" I have taken you through a trick to address this. Here... Continue Reading →
In the first part of this VLOOUP series, I have taken you through a simple example of VLOOKUP where while searching for the lookup value, we were doing an exact match. Now lets see an example scenario of approximate match. Scenario: You have a table showing the percentage of discount to be given to the... Continue Reading →
Here I thought of compiling a learning series covering the basics to classics of Excel Lookup functionality. So I have divided them into parts organized in some logically organized fashion. However, you are free to access and learn them in any order. Part 1: Introduction to VLOOKUP Part 2: VLOOKUP: Approximate match example Part 3:... Continue Reading →
