How to Use Index and Match in Excel for Advanced Lookups

Figuring out actionable insight is the primary goal for any database. Microsoft Excel offers the VLOOKUP and HLOOKUP functions to find data from a large spreadsheet. However, these functions aren’t flexible enough.

via MUO - Feed https://ift.tt/v6WTu0H