#INVALID OPERATION

Eden

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

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