I know how to write Excel formulas, but I just don't need to. Memorizing argument order for XLOOKUP or counting parentheses in a nested IF has never been the interesting part of working with data.

I also introduce this content in a short video. When managing sales or order sheets in Excel, you will almost certainly stumble over VLOOKUP at least once. You want to display a unit price after ...