Download Files:
Start File: [ Ссылка ]
Finished File: [ Ссылка ]
Entire page with all Excel Files for All Videos: [ Ссылка ]
Learn how to lookup the price for PVC Pipe in three different tables using VLOOKUP and INDIRECT Function and Defines Names. Defined Names allow us to assign a Named Reference to a lookup table. The INDIRECT Function allows us to use the table name entered as text in each transaction to access the Defined Name Price Lookup Table. VLOOKUP allows us lookup the price based on the Pipe Size entered for each transaction.
Related Video:
Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?
Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?
[ Ссылка ]
![](https://i.ytimg.com/vi/fjgFQ-YaOZE/maxresdefault.jpg)