Share via

Do I have the Map and Lamda functionality

Grant Straiton 0 Reputation points
2026-04-27T13:09:13.19+00:00

Do I have the Map and Lamda functionality in my version of Excel 365

Microsoft 365 and Office | Excel | Other | Windows
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 875.1K Reputation points Independent Advisor
    2026-04-27T13:43:57.0233333+00:00

    1

    Open Excel.

    Go to File - Account.

    On that window, what version of Microsoft Office is indicated as installed on your PC, please provide a screenshot of that window and if your Email appears in the screenshot, please hide it, this is a public user forum.

    2

    Log into your Microsoft account on this link, what Office licence do you find linked to your Microsoft account there.

    https://account.microsoft.com/services/

    Was this answer helpful?

    0 comments
  2. 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.

    1 deleted comment

    Comments have been turned off. Learn more

  3. Grant Straiton 0 Reputation points
    2026-04-27T13:13:27.3833333+00:00

    How do I update my version to get access to this functionality?

    Was this answer helpful?

    0 comments
  4. Q&A Assist
    2026-04-27T13:09:24.9566667+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    MAP and LAMBDA are available in Excel for Microsoft 365, Excel for Microsoft 365 for Mac, and Excel for the web, but only if the installed version is new enough.

    From the context:

    • LAMBDA is listed as a logical function available starting in Excel 2024 and Excel for Microsoft 365.
    • MAP is also listed as a logical function available in Excel 2024 and Excel for Microsoft 365.

    To determine if they are available in a specific Excel 365 installation, check whether the Excel build includes these 2024 functions. If the Excel version is current enough to include Excel 2024 features (for example, it shows functions like MAP, MAKEARRAY, REDUCE, SCAN in the function list), then MAP and LAMBDA are present. If those functions are not recognized, the installed build is older than the required version and does not support them.

    References:

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.