Perform a Lookup Based On a Value Between Two Values

By default, when you perform a look up (VLOOKUP or INDEX/MATCH) in Excel, you can only match a value either by exact match or approximate match. If you want to look up a value in a range or between two dates, you can use something called array formula. In this...

Find the Last Row and Last Column in Excel using VBA

When writing VBA, one of the most important things is to figure out the table dimension, like figuring out the last row and last column of a table. Using VBA, we can easily write just few lines of code to find the last row and last column index....

Create a Vlooup Function To Extract All The Associated Values

One of the limitations with Excel VLOOKUP function is that, when you have multiple matched values, the function will return the first matched record. In this tutorial, I will show you how to create a Used Defined Function (UDF) to perform VLOOKUP that can extract...