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 Day 1 Data Day 2 Data Project Probability Project Probability Prior Day AA 30 AA 30 30 BB 40 BB 60 40 CC 30 CC 40 30 CC 50 CC 80 50 CC 60 CC 100 60 DD 20 DD 20 20 EE 40 EE 40 40 FF 60 FF 80 60 FF 70 FF 90 70 GG 30 GG 50 30 GG 40 GG 90 40 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter harinsh
Start date Jan 8, 2019
Tags

data look for a value look up formula look up related data prior_day

harinsh

Active Member

Jan 8, 2019

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

Day 1 Data		Day 2 Data
Project	Probability	Project	Probability	Prior Day
AA	30	AA	30	30
BB	40	BB	60	40
CC	30	CC	40	30
CC	50	CC	80	50
CC	60	CC	100	60
DD	20	DD	20	20
EE	40	EE	40	40
FF	60	FF	80	60
FF	70	FF	90	70
GG	30	GG	50	30
GG	40	GG	90	40

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