This could result in unnecessary calculations, reducing the performance of your spreadsheets. As a result, it typically references more cells than it truly depends on.
In fact, it’s so fundamental to spreadsheeting that most users can recall the sense of achievement they felt when they first mastered VLOOKUP, myself included. For 35 years, VLOOKUP has been the first lookup function learned by Excel users and our 3rd most used function (after SUM and AVERAGE). VLOOKUP has been with Excel from the beginning it was included in Excel 1 for Macintosh released in 1985. Before I describe XLOOKUP, I want to take a moment to reflect on VLOOKUP's incredible history and impact on spreadsheeting. We are excited to announce XLOOKUP, successor to the iconic VLOOKUP function. It will be available to users in Semi-Annual (Targeted) channel starting mid April 2020. XLOOKUP is now available to all Office 365 Subscribers in the Monthly Channel and will be available to users in the Semi-Annual Channel starting in July.