• How to Use VLOOKUP, HLOOKUP, and INDEX MATCH in Excel

    Say you have a table of data and you want Excel to look up a certain value and return a corresponding value in a different row. For that, you need a lookup function. Excel has a range of functions that you can use to achieve this including VLOOKUP() and HLOOKUP() and the more flexible - but slightly more complicated -combination of INDEX() and MATCH().