Share via

@index limit

Anonymous
2022-09-03T19:27:26+00:00

Is there a reason why @index match function doesn't work sometimes? I copy/paste the formula across with 7 @index within one formula, and I found sometimes it only picked 5 instead of 7, do you know if there's a limit to formula characters or why this formula doesn't work properly sometimes?

Microsoft 365 and Office | Excel | For business | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-03T20:15:13+00:00

    Dear Kay,

    Good day! Thank you for posting in Microsoft Community.

    If it is convenient, could you upload some screenshots about the sample data and the formula you are using for our reference so that we can see if the formula works at our side and check whether there are some alternative ways achieving your requirements?

    Note: Remove any private information before uploading the screenshots.

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments