Excel Magic Trick 1352

Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?

DESCRIPTION

See how to create a formula that simultaneously looks up 3 item, joins then together in a single cell in order to produce a system code for CompanyName/PlantZipCode/. See 4 formula methods, including timing of calculation time for each formula:
(00:15) Introduction
(01:54) Formula 1: 3 VLOOKUP Exact Match functions
(04:45) Formula 2: 1 VLOOKUP Approximate Match function with Array Operation and the special keystroke Ctrl + Shift + Enter
(08:52) Formula 3: 1 INDEX & MATCH Approximate Match with Array Operation
(12:23) Formula 4: 3 LOOKUP Approximate Match functions
(15:12) Timing formula calculation time for each formula
(17:26) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book
(17:38) Summary

WORKBOOKS

Download “Excel-Magic-Trick-1341-1360.zip” Excel-Magic-Trick-1341-1360.zip – Downloaded 6363 times – 23 MB




Be the first to comment

Leave a Reply