Hi all,
Can index matching be use in the below situation? If so how should I proceed it?
I've a set of data in Sheet("Data") and a list of different rates in Sheet("Rates").
If column X in Sheet("Data") falls within any combination of columns B and C, or B and D, or B and E in Sheet("Rates") then copy column G to Sheet("Data").
Column B and C in Sheet("Rates") are dates if it's a combination of B and C and dates falls within will return column G in Sheet("Rates").
There are other criteria other needs to meet please see my attach workbook for better explanation, as I'm not really good at explaining.
Thanks
Bookmarks