Looking to populate the ID with the largest nth Value in L15 :P15 based on the following conditions.
Date is 10/17
location is North
=INDEX(A:A,MATCH(LARGE(IF(AND(D:D=L13,B:B=K15),C:C),1),C:C,0))
formula does not work, looking for the appropriate formula
ABCDEFGHIJKLMNOP1IDLocation Value...