News

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

    by James Wann
    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().
    Posted in Excel, HLOOKUP, INDEX, INDEX MATCH, MATCH, Online Training, Spreadsheet, Training, VLOOKUP