Look Who it Was Random video

Excel Magic Trick 979: 2 Lookup Values in Lookup, Can't Have Helper Column.

4,611 views · Published 15 December 2012 · 7:27 · Indexed 29 October 2026

Channel: excelisfun · 2012 · Education

Watch on YouTube

Download Excel Start File:  https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT979-980.xlsm

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Topics for Two 2 Lookup Values in Lookup, Can't Have Helper Column:
1. INDEX and MATCH Array Formula when columns are not sorted and you ned a formula that you can copy down a column.
2. DGET when you have a database with field names and you DO NOT need to copy the formula down a column.
3. LOOKUP functions if you can sort by 2 columns, helps to avoid Ctrl + Shift + Enter.

2 lookup values VLOOKUP?

More from this channel