Excel Magic Trick 1499: VLOOKUP or INDEX Joins to Create Transaction Description (3 Examples)

258

7930

Download Excel File: https://excelisfun.net/files/EMT1499-1500.xlsx Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm In this video learn how to create a description for a transactional data set that requires that we lookup items to join with the Transaction Number. See how to use the Ampersand, the join operator, and how to use the lookup functions VLOOKUP function and INDEX & MATCH functions. 1. (00:06) Introduction 2. (01:20) Two VLOOKUP functions in single formula solution 3. (04:33) Join Column in Lookup Table Solution (and one VLOOKUP) solution 4. (05:52) Array Formula with INDEX and MATCH functions with joined lookup columns in an Array Operation and an Array Formula. 5. (09:32) Summary

Published by: ExcelIsFun Published at: 5 years ago Category: آموزشی

Excel Excel 2016 Highline College Mike Girvin excelisfun Excel Magic Trick Accounting Excel Invoice Excel Two VLOOKUP functions in single formula VLOOKUP Function Join Column in Lookup Table Solution INDEX and MATCH functions Array Operation Array Formula Concatenation in Excel Join Operator in Excel Formula to Create Description Excel Text Formulas Ampersand the join operator Join Operation Join Array Operation dideo دیدئو vlookup lookup excel join functions array create transaction