I need to compare the second range value with the first one and get the Interest Rate column filled for the second range from the first one.
Here is the business rule. The first date cell value in the second range would be compared with the list of date values in the first and if the date cell value is less than or equal to any of the date list values in the first range, and the corresponding charge code value is "INTEREST" for the date cell value in the second range, the Rate of Interest column value in the first range needs to be gotten populated in the Interest Rate column of the second range.
Any formula or VBA code would help greatly.
Thank you in advance for your valuable solution.