Looking up a module populated with same numbers
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 "asis" 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?
Account  Product  Q1  Q2  Q3  Q4 
A1  P1  111  222  333  444 
A1  P2  111  222  333  444 
A1  P3  111  222  333  444 
Thanks and regards,
Clarence
Best 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
0
Comments

Many thanks @anand.shekhawat !
0