searching through row

[Anas_Raza]

I have weekly target sheet in which six columns are occur
Like this:
[TABLE="width: 659"]
<tbody>[TR]
[TD]Week
[/TD]
[TD]Description
[/TD]
[TD]PREVIOUS REMAINING
[/TD]
[TD]TARGET
[/TD]
[TD]TOTAL TARGET
[/TD]
[TD]ACHIVED
[/TD]
[TD]DIFFERENCE
[/TD]
[/TR]
[TR]
[TD]18(30-Apr to 06-May)
[/TD]
[TD]XYZ
[/TD]
[TD]2
[/TD]
[TD]5
[/TD]
[TD]7
[/TD]
[TD]4
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]

I want to put a formula in pervious remaining colum that automatically search what I write in description column from previous entries and put the last value of difference colume.

 

[Anas_Raza]

I want to write a formula in pervious remaing cell (colume) that look up text of description in above data and tell me last value of last diff cell where xyz written

if i write xyz again in description column then the formula that i put in previous remaining row search xyz in previous data and tell the last value that i had put in remaining while i had write xyz in description column before.

 

[Anas_Raza]

when i write xyz again in description then required formula search xyz in pervious data and put the value of diff when i wrote xyz row before

 

[Peter_SSs]

I want to write a formula in pervious remaing cell that look up value of description in above data and tell me last value of last diff cell where xyz written

This is an array formula so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}. The formula can then be copied down.

Excel Workbook
	A	B	C	D	E	F	G
1	Week	Description	PREVIOUS REMAINing	TARGET	TOTAL TAR	ACHIVE	DIFF
2	18(30-Apr to 06-May)	XYZ	2	5	7	4	1
3	18(30-Apr to 06-May)	abc	2	4	6	3	3
4	18(30-Apr to 06-May)	poi	3	2	5	3	2
5	18(30-Apr to 06-May)	oiu	1	5	6	4	2
6	19(07-May to 13-May	XYZ	1	4	5	2	3
7	19(07-May to 13-May	abc	3	4	7	6	1
8
9
10	20(14-May to 20-May)	XYZ	3	3	6	4	2
11	20(14-May to 20-May)	ABC	1	4	5	4	1
Last value

 

[Anas_Raza]

Thank you,Peter
May God increase your knowledge and wisdom

 

[Peter_SSs]

Thank you,Peter

You are welcome.