Share via

Downloading the XLOOKUP function as Excel Add-in for version 2016

Anonymous
2023-05-15T20:09:52+00:00

Hello community,

I am trying to obtain the XLOOKUP function to install as an add-in for version 2016. I've looked into this online, have followed instructions, and I have not had success. I have read the comments of others who have tried the same thing and they claim to have been successful. I am not sure I am getting the right file. I could use some assistance with this. Thank you. BH

Microsoft 365 and Office | Publisher | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-05-15T20:37:00+00:00

    You cannot "download" XLOOKUP and other new functions in Excel 2016. They are only available in Excel in Microsoft 365 and Office 201 (and in the online version of Excel).

    You can find custom XLOOKUP-like functions on the internet, but they cannot emulate XLOOKUP 100%, since the latest versions of Excel support dynamic arrays; older versions don't.

    60+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-12-01T15:13:15+00:00

    plesase xloocup fuction insttalation of pc in chapora

    30+ people found this answer helpful.
    0 comments
  3. Anonymous
    2023-05-16T19:31:20+00:00

    I thought that might be the case. Wanted to know what my options were. Appreciate the help.

    10+ people found this answer helpful.
    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  5. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more