Share via

All LAMBDA helper functions returning #VALUE! error

Anonymous
2023-10-02T08:44:50+00:00

Hello!

I have a very basic query and I'm not able to find a solution despite searching on multiple forums. So here's a screenshot of the issue I've been facing:

  1. I have an active personal Microsoft 365 subscription
  2. The basic lambda function of excel seems to be working fine here
  3. But whenever I try to use the lambda helper functions I get the #VALUE! error

I'm not sure if I'm missing something here, but would greatly appreciate inputs on how to resolve this.

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

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
Answer accepted by question author
  1. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2023-10-02T09:52:11+00:00

    When you type =SC does SCAN appear in the function list? Which version and build of 365 do you have?

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-10-03T03:18:07+00:00

    When you type =SC does SCAN appear in the function list? Which version and build of 365 do you have?

    Hello Rory!

    To answer your first question: Yes, it does show SCAN in the function list when I type "=SC" (with all relevant tooltips).

    Coming to the second question: I'm not sure which version I had earlier, but after you specifically asked this, I went ahead to check and realized there were some updates waiting to be installed. So I simply updated them and this ended up resolving the issue!

    Currently my version is at Version 2309 (16827.20130).

    Thanks a lot Rory! I'll mark this as resolved now!

    0 comments