Hello Project Owner,
I believe I have the necessary expertise to crack any medium to large excel problem. I am new to Freelancing but not new to Excel. Just for a testimonial I wrote the below formula for one of my projects and it took me roughly 45 mins to write this formula and resulted in complete automation of a complicated logic. Try me ! Good luck - cheers!!
=($K4+($L4-$G4)*INDIRECT(CONCATENATE("Incremental_Recovery_Increase!",ADDRESS(ROW(Incremental_Recovery_Increase!$G$1)+MATCH($M4,Incremental_Recovery_Increase!$G$2:$G$16,0),COLUMN(Incremental_Recovery_Increase!$G$1)+MATCH($H4,Incremental_Recovery_Increase!$H$1:$K$1,0),4,1)))/25%+SUM(INDIRECT(CONCATENATE("Incremental_Recovery_Increase!",ADDRESS(ROW(Incremental_Recovery_Increase!$G$1)+MATCH($M4,Incremental_Recovery_Increase!$G$2:$G$16,0),COLUMN(Incremental_Recovery_Increase!$G$1)+MATCH($H4,Incremental_Recovery_Increase!$H$1:$K$1,0)+1,4,1) &":"& ADDRESS(ROW(Incremental_Recovery_Increase!$G$1)+MATCH($M4,Incremental_Recovery_Increase!$G$2:$G$16,0),COLUMN(Incremental_Recovery_Increase!$G$1)+5,4,1)))))*(1+$N4*INDIRECT(CONCATENATE("Incremental_Recovery_Increase!",ADDRESS(ROW(Incremental_Recovery_Increase!$G$1)+MATCH($M4,Incremental_Recovery_Increase!$G$2:$G$16,0),COLUMN(Incremental_Recovery_Increase!$G$1)+6,4,1))))