Dear Excel-Experts,
Needing a bit of help with a date range lookup with additional criteria problem.
Sample file is attached with the expected outcome.
There are two tables.
Column A & B contain an Account number plus a start date.
In Column C, I need the corresponding Value (column I) which matches the account number (column H) and is within the date range (columns J:K) for that account.
Accounts can have multiple listings in either table.
I have highlighted a few samples. if you need any clarifications etc. just let me know.
I try to stay clear of array formula to prevent slowing down excel as the full file has a fair amount of data.
Any help/pointers are much appreciated.
Bookmarks