Download Files:

Start File: [ Ссылка ]

Finish File: [ Ссылка ]

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:
1. (00:15) Introduction
2. (01:54) Formula 1: 3 VLOOKUP Exact Match functions
3. (04:45) Formula 2: 1 VLOOKUP Approximate Match function with Array Operation and the special keystroke Ctrl + Shift + Enter
4. (08:52) Formula 3: 1 INDEX & MATCH Approximate Match with Array Operation
5. (12:23) Formula 4: 3 LOOKUP Approximate Match functions
6. (15:12) Timing formula calculation time for each formula
7. (17:26) Ctrl + Shift + Enter: Mastering Excel Array Formulas Book
8. (17:38) Summary

Related Videos:
Excel Magic Trick 1282: Lookup And Return Multiple Items to a Single Cell: TEXTJOIN Function
[ Ссылка ]
Excel Magic Trick 901: Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cell
[ Ссылка ]

свернуть