In this tutorial, we explored the column index number in the VLOOKUP formula and how you can fetch it automatically using two functions: COLUMN and MATCH. Learn more about the VLOOKUP function in ...

For example, even though the Cavalleria pirate ship is on Excel row 16, it’s actually row 15 in our formula because our range begins on A2 and goes through I16. If A2 is row 1, then A16 is row ...

Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP. Produced by Sara Silverstein.

In this post I want to show you how to do something I have shown before using OFFSET, but this time using the more efficient INDEX. Let’s look at the example of a 12 month budget spreadsheet with the ...

Figure 1. Example-driven query paradigm for specifying data transformation tasks. Transform Data by Example is an Excel add-in that helps you find the desired transformation function for your data ...