Index/Match - multiple criteria & greater than!

All

Looking for some assistance.....Please see attached, extract is a list of the inventory and I am trying to get the latest "circuit" for a particular customer. I have used the index/match function and match by:

Customer (abc)
Product (WAN)
Type (Access)
Resil (Solo)
MAX date for access related to particular customer
but as old circuit comes out on the same day as new circuit it picks the first in the row (which is the old circuit) so was hoping to add an extra match of MRC >0 but cant work it out.

https://app.box.com/s/cdqthnxkwdcp13wvgqjg

Maybe there is an easier way to do this though?

Any help would be most appreciated

Thanks
Andrew

Hi and welcome to the forum

Many members are unable (or unwilling) to download files from file-hosting sites - especially with a "file name" like that??

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Maybe your file is too large? (I think the max is 1 meg) Try to remove anything not related to your question

either that, or make up a dummy file that shows the same thing?

as long as days in ascending order
with or without duplicates
=INDEX(G3:G6,MATCH(L2&L3&L4&L5&MAX(IF($C$3:$C6=$L2,$H$3:$H6*ROW($H$3:$H6))),C3:C6&D3:D6&E3:E6&F3:F6&H3:H6*ROW(H3:H6),0),0)