Welcome. I'm trying to get a formula that enables me to fetch the last value in a column by several criteria. The product name (which may be repeated several times) is in column E and the date is in column A. I tried to put this formula in place. It actually brings the last value, but ignores the date requirement.
=IFERROR(INDEX(Sheet1!$J$5:$J$10000;MATCH(2;1/(Sheet1!$E$5:$E$10000=B15)));"")
=IFERROR(INDEX(Sheet1!$J$5:$J$10000;MATCH(2;1/(Sheet1!$E$5:$E$10000=B15);MATCH(2;1/(Sheet1!$A$5:$A$10000<=B10))));"")
=IFERROR(INDEX(Sheet1!$J$5:$J$10000;MATCH(2;1/(Sheet1!$E$5:$E$10000=B15)));"")
=IFERROR(INDEX(Sheet1!$J$5:$J$10000;MATCH(2;1/(Sheet1!$E$5:$E$10000=B15);MATCH(2;1/(Sheet1!$A$5:$A$10000<=B10))));"")