LOOKUP function Blank result

Hello everyone,

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.

Thank you in advance !

Yassine

ACHATS_YTD_ACCESS&PRECIOUS_module_screenshot_50339.png

Composant_list_screenshot_50339.png

Composant_module_screenshot_50339.png

module_test_2_screenshot_50339.png

Accepted answers

VIGNESH.M

Hi Yassine,

Try this,

Also check whether the item "080224" present in your list or not.

~Vignesh M

All comments

VIGNESH.M

Hi,

You are getting blank, because the lookup line item you used doesn't have any data.

Populate the Modele line item, then you will get the data.

Thanks,

Vignesh M

Yassine_Abdouh

I did populate the module with data, and yet its the same problem, even in the other module.

VIGNESH.M

Hi Yassine,

Search "080224" in your composant list, I think Composant Property is blank for this record. Please check.

~Vignesh M

kavinkumar

HI @Yassine_Abdouh,

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).

Regards,

Kavin.

Yassine_Abdouh

@VIGNESH.M

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.

Yassine_Abdouh

@kavinkumar

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.

kavinkumar

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.

I hope this solves your concern.

Let me know if you have any questions.

Regards,

Kavin.

Yassine_Abdouh

I get the following error when trying to convert the Module line item to a Composant list format :

and its because i am using this formula to fill data in the modele line item : IF LEFT(Article, 1) = "W" THEN Article ELSE LEFT(Article, 6). What should i do in this case ?

kavinkumar

Try this, FINDITEM('Composant',IF LEFT(Article, 1) = "W" THEN Article ELSE LEFT(Article, 6)).

Kavin.

Yassine_Abdouh

I get blank results? the "module 1" is like you instructed COMPOSANT list formatted

Thanks again for the help

VIGNESH.M

Hi Yassine,

Try this,

Also check, whether "080224" is present in your list or not.

~Vignesh M

VIGNESH.M

Hi Yassine,

Try this,

Also check whether the item "080224" present in your list or not.

~Vignesh M

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…