Skip to Content
Former Member
May 20, 2014 at 12:52 PM

Dimension value based on cell referece



I've a requirement with GLAccount and Trading partner in rows. I need to derive the trading partner based on the property of GLAccount.

Note: This inputschedule is dynamic (ACCOUNTS may change depending upon the selection).

Example: GLAccount is in Cell A and Trading Partner is in Cell B. Following is the formula applied on Trading Partner to derive based on the property of GLAccount.

Issue: Cell reference A1 is static in the formula. It is always refering to the GLAccount of cell A1. Ex: If Account1 Property value is I_NONE and others are T100


Account1 I_NONE

Account2 I_NONE

Account3 I_NONE

Expected result:

Account1 I_NONE

Account2 T100

Account3 T100

Formula on Trading Partner : Following formula cell reference is not dynamic to refer the corresponding GLAccount cell.


I appreciate your help.