find the next data

[amirsaeed]

assume i have a table like bellow

456	2486
789	6842
456	8624
123	4862	=
456	9713
123	7139
789	1397
456	3971
123	6985

<tbody>
</tbody>

i want excel to
for example i'm in column C4
i want to find next 123 below A4(which is 123) then add its B column to B4(which is 4862)
in this example the cell would be A6(which is the next 123 in column A below A4)

 

[Aladin Akyurek]

How is different from your post in: http://www.mrexcel.com/forum/excel-questions/910752-two-statement-time.html#post4379640?

 

[amirsaeed]

How is different from your post in: http://www.mrexcel.com/forum/excel-questions/910752-two-statement-time.html#post4379640?

i want excel that every time i write 123 in column A, excel finds the last 123 from column A and then add their B column with each other
for example if i wrote 123 in the A10 i want excel to find the A9 and add B10 with B9
it's too hard to explain my purpose i hope you understand what i mean
thank you in advance

 

[amirsaeed]

i want excel that every time i write 123 in column A, excel finds the last 123 from column A and then add their B column with each other
for example if i wrote 123 in the A10 i want excel to find the A9 and add B10 with B9
it's too hard to explain my purpose i hope you understand what i mean
thank you in advance

in other word i just want the last 123 from column A not all of them

 

[Aladin Akyurek]

assume i have a table like bellow

456	2486
789	6842
456	8624
123	4862	=
456	9713
123	7139
789	1397
456	3971
123	6985

<tbody>
</tbody>

i want excel to
for example i'm in column C4
i want to find next 123 below A4(which is 123) then add its B column to B4(which is 4862)
in this example the cell would be A6(which is the next 123 in column A below A4)

i want excel that every time i write 123 in column A, excel finds the last 123 from column A and then add their B column with each other
for example if i wrote 123 in the A10 i want excel to find the A9 and add B10 with B9
it's too hard to explain my purpose i hope you understand what i mean
thank you in advance

in other word i just want the last 123 from column A not all of them

These specifications do not cohere. Care to write down what value or values must obtain given the value of 123 as criterion?

Row\Col	A​	B​	C​
1​	X	Y	Z
2​	456	2486
3​	789	6842
4​	456	8624
5​	123	4862
6​	456	9713
7​	123	7139
8​	789	1397
9​	456	3971
10​	123	6985