Loading...

Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula.

14,319 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

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).

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...