Hi All,
I hope all of you are safe and well!
I have a drop-down in B2 called Region and B3 with Names of Sales Rep based on Region. The formula used for the same was an Indirect function based on Region from which It's pulling name. I have made a sheet called mapping where I have updated those changes.
When I am trying to use Indirect function in "Account Code". It gives an error message shared below
View attachment 19014
Is it because the value derived in Name is through an Indirect function which is not recognized by the formula when used in Account Code.
This is the mapping sheet. I have created with name range under APAC & EMEA you can see Name of Sales Rep, and Under Each sales Rep, there is an Account code.
I hope all of you are safe and well!
I have a drop-down in B2 called Region and B3 with Names of Sales Rep based on Region. The formula used for the same was an Indirect function based on Region from which It's pulling name. I have made a sheet called mapping where I have updated those changes.
When I am trying to use Indirect function in "Account Code". It gives an error message shared below
View attachment 19014
Is it because the value derived in Name is through an Indirect function which is not recognized by the formula when used in Account Code.
Region | APAC |
Name | Q1 |
Account Code |
This is the mapping sheet. I have created with name range under APAC & EMEA you can see Name of Sales Rep, and Under Each sales Rep, there is an Account code.
APAC | EMEA | ||||
Q1 | W1 | ||||
Q2 | W2 | ||||
Q3 | W3 | ||||
Q1 | Q2 | Q3 | W1 | W2 | W3 |
XZY | XY | X | ABC | AB | A |
XZY1 | XY1 | X1 | ABC1 | AB1 | A1 |
XZY11 | XY11 | X11 | ABC11 | AB11 | A11 |
XZY111 | XY111 | X111 | ABC111 | AB111 | A111 |