You can make use of Xlookup in Excel 2016, 2019 or any other version mentioned above using a custom function or any macro utility which is being discussed here.įollow the article to get the free addin and use Xlookup in Excel 2016, 2019 or other versions. USE XLOOKUP IN EXCEL 2016,2013,2007,2019 OR ANY OTHER VERSION & amp lt h2& amp gt & amp lt a href=””& amp gt Summer Sale 2021 970×90& amp lt /a& amp gt & amp lt /h2& amp gt IF YOU HAVE EXCEL 365, YOU DON’T NEED THIS ADDIN. THE ADD-IN IS CREATED IN THE FORM OF A UTILITY FOR EASY USE. This article provides you an ADD IN and tells its usage which can be used in place of the XLOOKUP FUNCTION. So, created a version of this using VBA for our readers so that they don’t miss this opportunity for using this awesome function. It returns the value or the complete array at once as per the selection.Both of these functionalities were not available in the previous versions.īut, the biggest problem is that this function is not available for any of the versions except OFFICE 365 which means no version earlier to OFFICE 365 like Excel 2019, 2016, 2013,2010 or 2007 have this function.
XLOOKUP function lets us lookup in any column in the table whether it is to the extreme left of the lookup table or right or anywhere in the middle. The XLOOKUP is very much advanced and versatile when compared with the previous versions of lookup functions like XLOOKUP is a newly flavored lookup function provided in OFFICE 365. Where can I find case sensitive XLOOKUP? INTRODUCTION.Which Versions of Excel support XLOOKUP?.