Excel
VLOOKUP, HLOOKUP and XLOOKUP: one practical Excel example
A formula can return a number and still point to the wrong product. I walk through a small product lookup, then deliberately break the data to show what needs checking.
Tag
reference functions
KajoData articles about reference functions. Practical knowledge about data analysis, tools and careers.
Articles: 1