*DON'T WORRY ABOUT THE SECURITY WHEN DOWNLOADING AND INSTALLING THESE ADDINS. SOMETIMES, DUE TO SETTINGS ISSUES IF THE BROWSER TRIES TO OPEN THIS FILE AND SHOW YOU ABSURD CHARACTERS, RIGHT-CLICK ON THE BUTTON>SAVE LINK AS>CHOOSE LOCATION AND SAVE THE FILE. Save both the files in the desired location. Use this function when the built-in functions don’t work for you as VBA functions are a bit slower inherently.ĪDDIN is like a small installation to your MICROSOFT EXCEL software which adds to the capabilities of the EXCEL.ĬLICK ON THE BUTTON BELOW TO DOWNLOAD THE ADDIN FOR GKXLOOKUP FUNCTION and its executing macro.ĪFTER CLICKING THE BUTTON ABOVE, a file named gkxlookup_addin.xlam and gkxlookup_admin.xlam will ask your approval to save.Complete look up can be done in one go.Any column can be looked up and any column can be retrieved.It gives CASE SENSITIVE INFORMATION such as two values differing only in the case. When you want to retrieve the information from a table by looking up any value and return a single value or a complete array.The function is very specifically meant for the situations such as: GKXLOOKUP is a simple utility that acts like the XLOOKUP FUNCTION but it is available to all versions of EXCEL whether it is EXCEL 2019, or Excel 2016 or any previous versions. IF YOU HAVE EXCEL 365, LEARN XLOOKUP HERE. THE ADD-IN IS CREATED IN THE FORM OF A UTILITY FOR EASY USE.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |