Excel Magic Trick 1458

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

DESCRIPTION

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.

WORKBOOKS

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







Be the first to comment

Leave a Reply