Forum Discussion

John_Bloggsajohnso9's avatar
John_Bloggsajohnso9
Copper Contributor
Jul 03, 2024

What is wrong with the following equation?

I can't get the following formula to work     =FORECAST.LINEAR(L20,{XLOOKUP(L20,B26:B30,B26:B30,,-1),XLOOKUP(L20,B26:B30,B26:B30,,1)},{XLOOKUP(L20,B26:B30,D26:D30,,-1),XLOOKUP(L20,B26:B30,D26:D30,...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 04, 2024

John_Bloggsajohnso9 

 

If HSTACK is not available in your version of Excel you can simulate it as follow:

=FORECAST.LINEAR(L20,
  CHOOSE({1,2}, XLOOKUP(L20,B26:B30,B26:B30,,-1), XLOOKUP(L20,B26:B30,B26:B30,,1)),
  CHOOSE({1,2}, XLOOKUP(L20,B26:B30,D26:D30,,-1), XLOOKUP(L20,B26:B30,D26:D30,,1))
)

(not tested but should work...)

Resources