Reference data like Excel's Xlookup function on SAC.

[Koei]

I would like to build a formula on SAC that references data from different models (or sheets in the case of Excel).
In this case, I believe that there is a possibility to handle this by utilizing Lookup on SAC, but I would like to confirm how to do so.
In the case of Excel, I would like to create a formula on SAC with the following conditions.
(search value is A1, search range is column A of Sheet2, return value is column B of Sheet2)
--------------------------
=XLOOKUP(A1,Sheet2!A:A,Sheet2!B:B)
--------------------------
When referencing data from different models, I would like to know how to do this as well, if it is necessary to match the data with the model to be quoted in advance.

#lookup #xlookup

[N1kh1l]

@Koei 

You can use LOOKUP(), ACCOUNTLOOKUP(), MEASURELOOKUP() to lookup data from a single model by providing the lookup criteria in terms of dimension filters. Its not possible to a cross model lookup from another model. Refer to the SAC help page for syntax and examples.

If you use SAC Excel you can use all Excel lookups formulas.

Nikhil

[dspokoinyi]

Hi, this already exist 

You have a lookup in the model calculations 

See here: https://community.sap.com/t5/technology-blogs-by-members/sac-lookup-function-in-model/ba-p/13524649