ExcelMentee
Banned  Rules violations
 Joined
 Jan 11, 2021
 Messages
 31
 Office Version

 365
 Platform

 Windows
I have Two sheets name are Sheet1 and Sheet2. Sheet1 has different values in Quarters and Months.
Sheet2 have start date and end date which is populate months according to the dates.
Sheet1 ColB = Years and ColC = Months. I am looking for a formula which automatically assume it by matching the Sheet1 months and quarters to give Col"E" result in Sheet2 according to Sheet2 months.
formula will always pasted the result in Mid of the quarter as i did manually in sheet2 n below picture.
Sheet1 Col"B" is months and Col"C" is Quarter and Col"E" value will be copied.
Sheet2 where the result is pasted in mid of the quarter.
Sheet2 have start date and end date which is populate months according to the dates.
Sheet1 ColB = Years and ColC = Months. I am looking for a formula which automatically assume it by matching the Sheet1 months and quarters to give Col"E" result in Sheet2 according to Sheet2 months.
formula will always pasted the result in Mid of the quarter as i did manually in sheet2 n below picture.
Sheet1 Col"B" is months and Col"C" is Quarter and Col"E" value will be copied.
Sheet2 where the result is pasted in mid of the quarter.