Forum Discussion
Solved
Can I get MATCH to grab the last identical value in an array?
Hi everyone - I am wresting with some MATCH challenges and would appreciate some help. In this case, my ideal outcome would be having MATCH grab the last value in a list of duplicate values (it defa...
Your desired results can be returned by solely using LOOKUP, like this starting in Row 2:
=LOOKUP(2,
1/((A$2:A$14=E2)*(C$2:C$14<=F2)),
B$2:B$14)
- You’re very much welcome. By the way, LOOKUP is my favorite function.