Referencing a Specific Cell

[wpatino15]

Hello,

I am fairly new to Alteryx and have been picking up some skills, but I am still far off from getting to the level that I would like to be. I need some assistance with a certain task and would greatly appreciate any assistance that I receive.. I want to do a task that would typically be simple in excel, but I can't seem to figure out how to do it in Alteryx. I have two problems that relate to referencing specific cells. Problem one is finding how to just reference a specific cell. The second problem is multiplying two specific cells. The data is below:

RecordID	Month	2012	2013	2014	2015	2016	2017	F14	F15	F16	F17	F18	F19	F20
13	Total	940	919	1059	1324	1559	1886
14	Average	78.33	76.58	88.25	110.33	129.92	157.17
15	Change	64	-2	12	22	20	27
16
17	Level	2	2	2	2	2	3
18	Amount	3000	3000	3000	3000	3000	1750
19
20
21
22
23			2013	2014	2015	2016	2017		2013	2014	2015	2016	2017	2018
24
25	Current Year Average		R	R	R	R	R		X	X	X	X	X	X
26	Previous Year Average			P	P	P	P			Y	Y	Y	Y	Y
27	Increase (Decrease)			D	D	D	D			D	D	D	D	D

The table above is what I'm working with. I put in letters in certain locations where I want to do something different. The letter coding is as follows:

R: I want it to reference the current year average from above based on its respective year. An example of this is the "R" under RecordID 25 under 2013. I want it to reference RecordID 14 under 2013. Then I want it to do that for the following years.

P: I want it to reference one of the previous year average. An example of this would be the "P" for RecordID 26 under 2014. I want it to reference the "R" under RecordID 15 under 2013.

X: I want it to multiply to different values. An example of this is the "X" under RecordID 25 under 2014 which is under Column F16. For that, I want it to multiply Column 2014, RecordID 15 by Column 2014, RecordID 18.

Y: Same thing as for P, but by using the values under X.

D: I think that I should be good with this part. I was able to do it before to find the Change, but just left that section there as a reference.

Please let me know if this is something that is possible or if there is a different approach that can be taken to solve it. Thank you in advance!

[ponraj · Accepted solution]

Attaching a sample workflow for your case.  Hope this is helpful. 

Sample DataWorkflowResult option-1Result option-2

[wpatino15]

Yes that definitely helped out. Thank you so much for your help! Just as a curiosity, is there no way to directly reference a certain "cell" like there is in excel?