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.

 

[Aladin Akyurek]

The ranges to consider are not specified...

=LOOKUP(9.99999999999999E+307,1/($B$1:B1=$B2),$G$1:G1)

Is this what you intend to have?

 

[Peter_SSs]

If Aladin's solution is not what you want, please post a slightly larger sample (say 6-8 rows) with the expected results manually entered & give any further explanation in relation to that new sample data.

 

[Anas_Raza]

Dear Peter
Thank you, please check my file form following link and then tell me formula


https://onedrive.live.com/redir?resid=BD034C310526AC1B!3685&authkey=!AK5RjgQmCeqPTa0&ithint=file%2cxlsx

 

[Peter_SSs]

Many of the helpers here choose not to download files from other sites or, due to security restrictions at work sites, are unable to download such files.

You will get many more potential helpers if you post your sample as a small (copyable) screen shot directly in your post. My signature block below has help regarding that.

 

[Anas_Raza]

 

[Aladin Akyurek]

See: Attachments lists a few methods for posting sample exhibits which do not require retyping and the add-in https://app.box.com/s/soezox25h3w0q5s4rcyl is also a method for posting an exhibit, as a link to dropbox or one drive does not provide a permanent record.

 

[Peter_SSs]

Further to Aladin's comments, even if your image had worked, we can't copy from it to paste into our sheets to test solutions.

 

[Anas_Raza]

[TABLE="width: 995"]
<tbody>[TR]
[TD]


[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Week
[/TD]
[TD]Description
[/TD]
[TD]PREVIOUS REMAINing
[/TD]
[TD]TARGET
[/TD]
[TD]TOTAL TAR
[/TD]
[TD]ACHIVE
[/TD]
[TD]DIFF
[/TD]
[TD]% ACHIVE
[/TD]
[TD]Remarks
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/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]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18(30-Apr to 06-May)
[/TD]
[TD]abc
[/TD]
[TD]2
[/TD]
[TD]4
[/TD]
[TD]6
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18(30-Apr to 06-May)
[/TD]
[TD]poi
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]5
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18(30-Apr to 06-May)
[/TD]
[TD]oiu
[/TD]
[TD]1
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19(07-May to 13-May
[/TD]
[TD]XYZ
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19(07-May to 13-May
[/TD]
[TD]abc
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD]7
[/TD]
[TD]6
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 12"]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
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Example
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20(14-May to 20-May)
[/TD]
[TD]XYZ
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20(14-May to 20-May)
[/TD]
[TD]ABC
[/TD]
[TD]1
[/TD]
[TD]4
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

How is the "Example" is related to the data in your upper exhibit? The figures you show for XYZ do not show up in the upper exhibit.