Hello,
Looking for some assistance with a formula that doesn't return correct info. I need my formula to index column "K" and return the data found (if any) but it has to be based on matching criterion, which includes matching account number as identified in cell G1 as well as the last matching date in J1. I tried using MAX, but couldn't get it to work. I need the formula to work in Excel 2016 or newer. Currently this is the formula I'm using, but I believe it is only finding the 1st date match and not the last.
Appreciate any suggestions!
Bookmarks