Looking up a module populated with same numbers

ClarenceAndre_*44012
ClarenceAndre_*44012
in Modeling

Hi I'm trying to lookup data in the format below. My LOOKUP formula is working but the issue is its only picking up the first record (Product P1). P2 and P3 are ignored as the numbers are the same. While this is counterintuitive, I need to work with data like this as the duplications could be either genuine or in error but the point is to read them "as-is" without second guessing their authenticity. How should one get LOOKUP to work in a situation like this or perhaps I should be using a different formula?

 

AccountProductQ1Q2Q3Q4
A1P1111222333444
A1P2111222333444
A1P3111222333444

 

Thanks and regards,

Clarence

 

Tagged:

Best Answer

  • anand.shekhawat
    anand.shekhawat
    Answer ✓

    Hi @ClarenceAndre ,

     

    It doesn't matter if the data fields are duplicated. If the formula is correct, Anaplan will always pick up the correct value without a doubt. 

     

    So coming to your matrix, if you want to fetch the value of a product for an account for a particular quarter. You need to apply lookup on both account and product. The formula might look like Value[Lookup:Account formatted line item,Lookup:Product formatted line item] for a specific quarter. If you don't have time dimension in your target module, you can use one more lookup using a time period formatted(quarter) line item. I have attached few items for your reference

     

    I hope it helps

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

Categories