Hi all, I am trying to figure something out and after nemerous searches and i still cannot find a post that does what I'm looking for. I basically have an ID(a) field, another field with Date(b) and a third field that I did the calculations for which gives me the Date(c) as well. I need to figure out whether value from c matches b, based on the ID in a e.g., (calculating sum based on year) IDDate-CurrentDate-PreviousPriceSum-CurrentSum-Previous123FY19FY181001000123FY19FY181001000678FY18FY1750500456FY19FY181001000456FY20FY19150125125456FY20FY19100125125 I basically do calculation for Date Previous which should give me the previous year Sorry if this is confusing, all I need to do is calculate the "Sum-Previous" field, but only sum the Price field if value of Date-Previous exists in Date Current based on the ID. Please let me know if I should specify anything else. Thank you

Match values between two columns based on ID from another column

Hi all,

I am trying to figure something out and after nemerous searches and i still cannot find a post that does what I'm looking for.

I basically have an ID(a) field, another field with Date(b) and a third field that I did the calculations for which gives me the Date(c) as well.

I need to figure out whether value from c matches b, based on the ID in a

e.g., (calculating sum based on year)

ID	Date-Current	Date-Previous	Price	Sum-Current	Sum-Previous
123	FY19	FY18	100	100	0
123	FY19	FY18	100	100	0
678	FY18	FY17	50	50	0
456	FY19	FY18	100	100	0
456	FY20	FY19	150	125	125
456	FY20	FY19	100	125	125

I basically do calculation for Date Previous which should give me the previous year

Sorry if this is confusing, all I need to do is calculate the "Sum-Previous" field, but only sum the Price field if value of Date-Previous exists in Date Current based on the ID.