Excel, Accelerated: Multi-criterial lookup for item costs, without XLOOKUP
Time: 1:56 | Task: Look up item costs from a specific invoice number (without XLOOKUP) | Context:Sales line item report | Acceleration techniques: CONCAT, table objects, VLOOKUP, COLUMNS | Bonus! Creating sample data: CHOOSE, RANDBETWEEN
-
1
-
Watch the Video and Download the Template