Hi to all!
Please, help. I need single cell forecast formula from four sheets. I already have concept(formula), but I don't know how to combine formula w/o helper columns X's Y's.
I'm stuck here: =FORECAST(F6/VLOOKUP(E6,IF(D6="R-7",Factors!A3:B165,Factors!E3:F195),2,FALSE),HOW TO INSERT HERE "XY" FROM ALL 4 RESERVOIR?)
Thank you for your help in advance.