Question on LOOKUP Function
Hello - I have a seemingly simple ask and need help. I have a module one DAT01 with two dimensions ( Country and Year ) and a line item Annual Percent Increase and I have another module, DAT02 with three dimensions Country, Product Family and Months. I want to reference Annual Percent Increase from DAT01 into DAT02. I am bit lost at how to use LOOKUP function since DAT01 doesn't have Product Family dimension and my formula is returning zeros.