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

Download Excel File: https://ift.tt/2snUDyL
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

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

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.