Order History
Premium Membership & Rewards
Help Center / FAQ
Excel XLOOKUP and Other Lookup Functions
Paperback
$10.99
Premium Members save an extra 10% and all Members collect stamps to save with Rewards. 10 stamps = $5.Learn More
Select a store to view item availability.
Leverage New Powerful Lookup Functions in Excel 2019
Dynamic array formulas represent one of the biggest changes to Excel formulas in years. Maybe the biggest change ever. They enable you to work with multiple return values at the same time in a formula. XLOOKUP is a new and exciting function that replaces VLOOKUP and addresses most of the limitations of its predecessor. XLOOKUP is so versatile that it also replaces HLOOKUP and the INDEX/MATCH/MATCH combination used for simultaneous vertica...