Professor Excel

2D Lookups in Excel: 4 Easy Methods for 2 Way Lookups + Excel Download

There are many cases in which you need a 2 dimensional lookup. That means, if you want to get a value from a specific row-column combination with neither rows or columns fixed. Unfortunately, the problem of a two way lookup comes up quite often. In this article we explore 4 methods of how to conduct 2D lookups in Excel.

[…]

index, match, excel, formula, vlookup

INDEX and MATCH: The Alternative to VLOOKUP in Excel

You’ve probably heard of the VLOOKUP formula in Excel, haven’t you? The VLOOKUP formula searches for a value in a column. Once found it returns another value from the same row. A combination of INDEX and MATCH serves the same purpose. It works slightly different and has therefore some advantages and disadvantages towards VLOOKUP. 

[…]