Is there a way to return a value from a different row in calculated column?

[msciarrino]

Hello All,

My goal is to find the value in the "Key" column for every row in the "Unique Tool ID" column and return that matched rows "Date" value. The matched row can be before or after the current row in my dataset. The values currently in the "Original Date" column are my expected results. I am trying to solve for the "Original Date" column.

Key	Date	Unique Tool ID	Original Date
ID1.0	1/1/24	ID1.0	1/1/2024
ID4.0	1/3/24	ID4.1	1/8/2024
ID3.0	2/20/24	ID3.0	2/20/2024
ID1.0	2/1/24	ID1.1	1/1/2024
ID4.0	1/8/24	ID4.0	1/8/2024

Thank you.

[lbendlin · Accepted solution]

see attached

[pramod_singh]

Use lookup function, i hope it will work.