Hi Team, I working with lakhs of row and apply Index match function with multiple criteria basis appliable date of particular name, which will take much time while processing, can you please help me out to get the VBA dictionary lookup with multiple criteria which give result in minimal time, so that I can utlize my time further for anlysing of data.
Below is the table where I need output:
With Criteria of Column A matched with Data Base file and Column C range >= in data base file column C and Column D<= in data base file column D
Data Base:
Below is the table where I need output:
With Criteria of Column A matched with Data Base file and Column C range >= in data base file column C and Column D<= in data base file column D
Data Base: