Tag Archives: XLOOKUP

Fixing inconsistent data type in lookup table in #Excel

Posted on December 11, 2021 by MF

A common VLOOKUP problem with an easy fix The situation – VLOOKUP fails… Have you ever encountered something like this? This is quite common. We are sure that the VLOOKUP formula is correct. We are sure that the lookup values … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , | 2 Comments

Be cautious when using XLOOKUP

Posted on November 30, 2019 by MF

Can you spot the error in the above formula? It’s not about the new function of XLOOKUP.  It’s about inevitable human error… If you are an Excel fan, you should be aware of the exciting XLOOKUP function in Office 365.  … Continue reading →

Rate this:

Posted in Formula | Tagged , , , | 10 Comments