Tag: xlookup

  • Excel: Looking up data continued

    Last week, I showed you the simplest form of the XLOOKUP function. Though highly useful, it’s only really useful if you find exact matches. If you’re looking at an array of data – e.g. pay averages for age groups instead of specific ages – you need to help it a little. To this end, the…

  • Excel: Looking up data

    This time, I show you how I look up data in a table using the XLOOKUP function.