Bring maximum value according to another row

[Syndicate_Admin]

Hello everyone

I tell you that I have a model which reads weekly excel files, so the information is changing

the problem I have is as follows

This changes by week, suppose the first value is from week 1 and I need to read the last one that is from week 5. create a function that will bring me the most current week but still when trying to use the VLOOKUPVALUE function but it tells me that several values are provided where only one was expected and it is logical since there are 2 different values, attached referential image of the values (TS Port1)

How can I read them?

Thank you very much in advance ❤️

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Use calculate max instead of lookupvalue

column = calculate(max(value),filter(...))

Best Regards,

Jay