Highline Excel 2016 Class 12

Two Lookup Values in VLOOKUP? Helper Column or Array Formula.

DESCRIPTION

In this video learn about:
(00:13) Introduction
(00:30) Helper Column Solution with Join Operator and VLOOKUP
(03:31) Array Formula with: INDEX and MATCH functions and a Join Array Operations. This formula requires Ctrl + Shift + Enter.
(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).

WORKBOOKS

Download “Highline Excel 2016 Class 12” Highline-Excel-2016-Class-12.zip – Downloaded 7 times – 722 KB




Be the first to comment

Leave a Reply