Forum Discussion
Index/Match Array issue
Hi I am trying to return a value based on multiple criteria using the index match function, but one of the criteria will need to return the latest date. The data is as below. I want to return...
I have no solution so far, but IMHO, both above shall not work if the maximum date in D:D (or in Table1[Date]) is out of range with searched item records. Here are nested arrays - first we have to define records with searched item (they could not be sequential in initial array), and within that range find the record with maximum date.
Hello Sergei,
you are right. When I change a date of an item that is not queried to be the max I get an #NV error, too. The original data looked like there was the same dates for every item. I assumed that was the general case in the original problem. If it is not, neither path works.
Jens