Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range
Автор: excelisfun
Загружено: 2015-08-30
Просмотров: 9318
Описание:
Download Excel Start File: https://excelisfun.net/files/EMT1232-...
Download File: http://people.highline.edu/mgirvin/ex...
Learn how to use a helper column formula to lookup a discount rate in 36 different tables:
1. (00:11) Introduction to problem we want to solve and look back to Excel Magic Trick 1231 & 1232
2. (00:47) Create “Smart” Titles for each of the 36 tables.
3. (01:27) Helper Column Solution with SEARCH function and a Function Argument Array Operation, LOOKUP function, Big Number 2^15 for lookup value, and LOOKUP result joined to Product Name.
4. (06:30) VLOOKUP with Joined (Concatenated) lookup_value.
Thanks to Kevin Lehrbass and his YouTube Channel!!!
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
