Looking up a module populated with same numbers

ClarenceAndre_*44012

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?

 

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

 

anand.shekhawat

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

A3_110242.JPG

A2_110242.JPG

A1_110242.JPG