#INVALID OPERATION

I'm trying to use a mix of IF, index,match, and max, but it keeps prompting me that INVALID OPERATION. Could you please help me find out what's wrong with what's wrong with the formulas? Thanks!

=IF({2024 leave master data for Admin ONLY Range 5} = Employee@row, INDEX({2024 leave master data for Admin ONLY Range 2}, MATCH(MAX({2024 leave master data for Admin ONLY Range 3}), {2024 leave master data for Admin ONLY Range 3}, 0)), " ")

Best regards

Eden

Find more posts tagged with

Accepted answers

All comments

SoS | Dan Palenchar

Hello @Eden,

I'd suggest using INDEX(COLLECT()) instead. See here for info.

Eden

I think INDEX(COLLECT()) can not meet my needs, I want to find this employee in 2024 leave master data for Admin ONLY this sheet in the latest date of the Annual Leave Left Days, but this formula shows #INVALID OPERATION. May I can ask if you can tell me how to set the formula? Thank you!

Eden

Dear @Dan Palenchar

Thank you for your help!

Best regards

Eden

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.