IF Formula for the data

[Mangesharalkar]

Hi Team, I am looking for If formula fir movement of Data from week to week Eg If Week "I" move to "P-W" it should show 20% and so on

Week1	Week2	%
I	P-W	20%
I	P-H	20%
P-W	I	-20%
P-W	P-H	20%
P-W	K	20%
P-H	K	0%
K	K-C	10%
K	CC	20%
K	K-R	-20%

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[JaccoVis90]

I would work with a VLOOKUP function. Copy this table on an extra sheet and make an extra column in between the week 2 and % with the function = A2&B2 (should return as IP-W
in the original sheet =VLOOKUP(C2,extrasheet!$C$2:$D$10,2,0)

Or use names for the range on the extra sheet

 

[Mangesharalkar]

I am looking for movement on week on week basis if in Week 1 if line item is "I" in next week it become "P-W" it should show 20% as movement . V look up in not helping in it

If in Week 2 it is Moved from I to P-W (If I do v look up by it it will not help) it will give me error)

Week1	Week2	CC	%
I	P-W	IP-W	20%
I	P-H	IP-H	20%
P-W	I	P-WI	-20%
P-W	P-H	P-WP-H	20%
P-W	K	P-WK	20%
P-H	K	P-HK	0%
K	K-C	KK-C	10%
K	CC	KCC	20%
K	K-R	KK-R	-20%
I	I	II	0%
P-W	P-W	P-WP-W	0%
P-H	P-H	P-HP-H	0%
K	K	KK	0%
K-C	K-C	K-CK-C	0%
CC	CC	CCCC	0%

<tbody>
</tbody>

Week 1 account movement	Week 2 account movement	Week 3 account movement	Week 4 account movement	0	1	2	3
				P-W	P-W	P-W	P-W
				I	I	I	I
				I	I	I	I
				P-W	P-W	P-W	P-W
				I	I	I	I
				I	I	I	I
				I	I	I	I
				I	I	I	I
				K	K	K	K
				I	I	I	I
				P-W	P-W	P-W	P-W

<colgroup><col span="4"><col span="4"></colgroup><tbody>
</tbody>