I am currently working on a model where i am using some data i imported in formulas to create some relevant data for a YTD model. I am trying to implement the following excel formula : IFERROR(VLOOKUP(A2;'TCD CRISTALLINE'!H:I;2;0);""). So in the first part of the implementation i started off by trying to use uniquely the LOOKUP formula, and so :
I created a list and imported all the data that i'll be needing into it (Composant list screenshot.png)
I created the module and formatted the data types with the dimensions ill be using (ACHATS YTD ACCESS&PRECIOUS module screenshot.png)
The column where i need to insert the formula above is the "ref pierre de centre" column, and so i used the following formula : COMPOSANT.Composant[LOOKUP: Modèle], which should simply look for the composant from the list above corresponding to each "modèle" item i have. However, i am not getting any values, and the whole column is blank. I also tried to create a module , take the list i needed as a dimension in a new module (Composant module screenshot.png) and import to it the "composants" data, and then use the formula Composant module.Composant[LOOKUP: Modèle] (module test 2 screenshot.png), but i get always the same result.
I hope i detailed well the case, if not, i'll glady give more information.
Not all cells contain the data, indeed the "080224" doesn't have a corresponding value of "ref pierre de centre", but for example the "J1MK00" does in my excel model. however, its blank in my Anaplan model.
Can you please confirm that the line item 'Modele' is Composant List formatted. It has to be else the formula wouldn't work properly. You need a connection/relation between your module (Source) and the list (Target).
the "Modele" is text formatted since i am getting the data in it using the formula : IF LEFT(Article, 1) = "W" THEN Article ELSE LEFT(Article, 6) in wich i am extracting the first 6 characters from my "Article" column, filled with data i imported.
Can you please convert the 'modele' line item to List formatted one(Composant). Create another line item with 'Composant list' formatted and write the formula 'FINDITEM('COMPOSANT', Modele)' then do a lookup based on this newly created one.