Can a result from Indirect formula be used to create another Indirect formula?

[RahulNa]

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.

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

 

[RahulNa]

Please ignore.

The issue is resolved.

Please let me know how can I delete a post which I have already posted. Not able to find any option.