Hi,

I'm new to this form...any form and I'm also trying to figure out the index match formula as well.

What I'm trying to do is use multiple criteria, from two tables, and return the last value that matches the criteria.

Here is the formula that I have so far, it is working to the point of returning the first match,

=INDEX(Table1!$M$5:$M$189,MATCH(1,(Table1!$K$5:$K$189=Table 2!O7)*(Table 1!$J$5:$J$189=Table 2!N7)*(J7>=Table 1!$H$5:$H$189),0))

Any pointers out there? Is this even the best formula to go with?

Thanks