INDEX MATCH to return values based on date comparison between 2 worksheets

[curious1]

Hi, struggling with producing an INDEX MATCH formula that will achieve the following:
For each Name in WS1, if its Date < 365 days from the Date of the matching Name in WS2, return "N" in WS1 Col C, otherwise return the value in WS2 Col C corresponding to that Name.
The results should be WS1 Col C in the example below.

Book1
	A	B	C
1	NAME	DATE	NEW LABEL
2	Name1	12/1/2021	N
3	Name2	12/2/2021	N
4	Name3	12/3/2021	S
5	Name4	12/4/2021	N
6	Name5	12/5/2021	F
WS1

Book1
	A	B	C
1	NAME	DATE	LABEL
2	Name1	1/20/2020	N
3	Name2	8/9/2021	IP
4	Name3	5/23/2019	S
5	Name4	9/1/2021	F
6	Name5	3/7/2020	F
WS2

Any help is deeply appreciated!

 

[etaf]

=INDEX('WS2'!$B$2:$B$6,MATCH('WS1'!A2,'WS2'!$A$2:$A$6,0))
will find the date in WS2

then you can take WS1 date away to get the number of days

Then use an IF()

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	NAME	DATE	NEW LABEL	Formula	Date WS2		Days
2	Name1	12/1/21	N	N	1/20/20		681		WS1, if its Date < 365 days from the Date of the matching Name in WS2, return "N" in
3	Name2	12/2/21	N	N	8/9/21		115
4	Name3	12/3/21	S	S	5/23/19		925
5	Name4	12/4/21	N	N	1/9/21		329
6	Name5	12/5/21	F	F	7/3/20		520
7
8
WS1

Cell Formulas
Range	Formula
D2:D6	D2	=IF(B2-INDEX('WS2'!$B$2:$B$6,MATCH('WS1'!A2,'WS2'!$A$2:$A$6,0))<365,"N",INDEX('WS2'!$C$2:$C$6,MATCH('WS1'!A2,'WS2'!$A$2:$A$6,0)))
E2:E6	E2	=INDEX('WS2'!$B$2:$B$6,MATCH('WS1'!A2,'WS2'!$A$2:$A$6,0))
G2:G6	G2	=B2-E2

Book1
	A	B	C
1	NAME	DATE	LABEL
2	Name1	1/20/20	N
3	Name2	8/9/21	IP
4	Name3	5/23/19	S
5	Name4	1/9/21	F
6	Name5	7/3/20	F
WS2

 

[curious1]

etaf: Thank you for the answer and the education! I did not have clarity on how to see and construct the solution correctly. I appreciated seeing your logic, which I applied to my actual data set to obtain the desired output. Worked! Then, ignoring the answer, I wrote an abstracted version of each INDEX/MATCH formula to help grasp what each needed to accomplish and nested those together into a conceptual formula. I then wrote the actual formula based on that summarization and it worked. I hope I will be able to "see" how to approach future problems given this example. Much appreciated!

 

[etaf]

you are welcome