Prior data in current data set by looking up the require field

[harinsh]

Hi Team,

I am looking for some help in getting the prior day data by compare with today's data table...refer the below two data set and help in formula to achieve the same..thank you


[TABLE="width: 398"]
<colgroup><col span="4"><col><col></colgroup><tbody>[TR]
[TD]Day 1 Data[/TD]
[TD] [/TD]
[TD][/TD]
[TD]Day 2 Data[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Project [/TD]
[TD]Probability [/TD]
[TD][/TD]
[TD]Project [/TD]
[TD]Probability [/TD]
[TD]Prior Day[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD]AA[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD]BB[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD]CC[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[TD]CC[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD]CC[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]DD[/TD]
[TD="align: right"]20[/TD]
[TD][/TD]
[TD]DD[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]EE[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD]EE[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD]FF[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]FF[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[TD]FF[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]GG[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD]GG[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]GG[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[TD]GG[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"]40

[/TD]
[/TR]
</tbody>[/TABLE]

End of the day in day 2 I need prior data column values by comparing the project and its probability

Let me know if you need further clarification. Thank you