How to find same value in one cell, but then copy value from another cell

[affee]

Hi all,

I like to pick your brains as my brains cant get around this problem.

I like my formula to work out the following.

I have a task in cell A2, I have a date of when the task was done in B2. Simple to start, but when going forward, I sometimes have to repeat the same task in A2 and write the date of the repeat task next to task done. My C2 cell should show if the task was done again and what date. Otherwise return false. As example below

Tasks	date	Re-done?
task 1	01/01/2022​	04/01/2022​
task 2	02/01/2022​	FALSE​
task 3	03/01/2022​	06/01/2022​
task 1	04/01/2022​	FALSE​
task 4	05/01/2022​	FALSE​
task 3	06/01/2022​	FALSE​

Task 1 was done on 01/01/2022 and done again 04/01/2022. At the moment I am scrolling down to see when it was done and put date manually. Can anyone create an automated formula that can pick up same task from Cell A and copy the date next to that cell into cell C.

Thanks in advance

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1	Tasks	date	Re-done?
2	task 1	01/01/2022	01/04/2022
3	task 2	01/02/2022	FALSE
4	task 3	01/03/2022	01/06/2022
5	task 1	01/04/2022	FALSE
6	task 4	01/05/2022	FALSE
7	task 3	01/06/2022	FALSE
Lists

Cell Formulas
Range	Formula
C2:C7	C2	=IFNA(INDEX(B3:B100,MATCH(A2,A3:A100,0)),FALSE)

 

[affee]

That has worked. Thank you

 

[Fluff]

You're welcome & thanks for the feedback.