Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names – Excel Magic Trick 1458

Download Files:
Start File: http://ift.tt/2wjdQDn
Finished File: http://ift.tt/2wDywsd
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
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.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.