Excel Magic Trick 1458

Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names


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.


Download “Excel Magic Trick 1455-1460” Excel-Magic-Trick-1455-1460.zip – Downloaded 59 times – 5 MB

Be the first to comment

Leave a Reply