Names in Lookups: VLOOKUP and XLOOKUP on Named Tables
This lesson is part of the course
In this lesson
You price a dealer order with lookups on the named price list (PriceList, Codes, Prices) and find the volume discount in a tier table you name yourself.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Why Names? $B$1 versus TaxRate Locked
- Using Named Constants: TaxRate, ShipFee, FreeShipFrom & MemberDiscount Locked
- Naming Ranges with the Name Box: SUM, AVERAGE, COUNTIF and SUMIF Locked
- Names in Lookups: VLOOKUP and XLOOKUP on Named Tables Locked
- Assumption Blocks and Scenario Inputs with Names Locked
- Naming Rules, Conventions, Scope and #NAME? Errors Locked
- Refactoring a Model from Cell References to Names Locked
- Capstone: A Named-Range Dashboard and Chart Locked