Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 16, 2016
Download Files: https://people.highline.edu/mgirvin/A... In this video learn about: 1. (00:13) Introduction 2. (00:30) Helper Column Solution with Join Operator and VLOOKUP 3. (03:31) Array Formula with: INDEX and MATCH functions and a Join Array Operations. This formula requires Ctrl + Shift + Enter. 4. (05:31) Array Formula with: INDEX, INDEX and MATCH functions and a Join Array Operations. This formula does NOT requires Ctrl + Shift + Enter because we put the Array Operation into the array argument in INDEX function and use a zero ( 0 ) in row_num argument to retrieve the whole column (Resultant Array from the Join Array Operation).