Alookup
🚀The new function that changes the rules of the game in the Excel world!
🌟 Using VLOOKUP or ? INDEX+MATCH Want to try XLOOKUP but your version of Excel is not up to date? Meet ALOOKUP - the function that will improve your search ability in Excel to a completely new level! Here are the main advantages of ALOOKUP:
1️⃣ Compatibility with all versions of Excel: XLOOKUP only works in the new versions, but ALOOKUP is compatible with all of them.
2️⃣ Flexibility in the order of the columns: with ALOOKUP the order of the columns does not matter - free search without limitations!
3️⃣ Search ranges and separate results: select data from non-adjacent columns without breaking your head.
4️⃣ Simplicity and user-friendliness: Keep formulas shorter and more readable.
5️⃣ Improved handling of errors: ALOOKUP includes advanced error checks that do not exist in INDEX MATCH.
6️⃣ Accessibility: At the click of a button, ALOOKUP will be available in any of your Excel files, as an empty file without a demo sheet!
✨ Join the hundreds of users who enjoy it and cannot work in Excel without it!
Don't pay Microsoft hundereds of dollars to use XLOOUP, buy ALOOKUP today.
Using the Alookup Function in Excel:
Example explanation: =Alookup(D2, B2:B17, A2:A17) searches for the value in D2 within the range B2:B17. If a match is found, it returns the corresponding value from the range A2:A17. If the value is not found, the function will return error messages similar to VLOOKUP.
Installation
Download the ZIP file to your computer
Right-click and extract the ZIP
Open the Excel file named ALOOKUP_install_as_addin.xlsm
Ensure macros are enabled on your computer (if not, refer to the guide on how to enable macros)
If you have a Windows computer, click on the button that looks like the image below to install the function as an add-in that will be available for all Excel files on your computer.
If you have a Mac computer, manually install the file named ALOOKUP_Mac users.xlam and do not use the green button.
Function Syntax:
Alookup(lookup_value, lookup_range, result_range, [match_type])
lookup_value: The value you are searching for. lookup_range: The range of cells containing potential matches. result_range: The range of cells containing the results of the potential matches.
Ensure that lookup_range and result_range are of the same size, otherwise, the function will report that the ranges are not of the same size.
[match_type]: Optional. 0 or omit for an exact match. 1 for a greater-than match (assuming the lookup array is sorted in ascending order). Returns the last matching value if multiple equal results exist. -1 for a less-than match (assuming the lookup array is sorted in descending order). Returns the first matching value if multiple results exist.