Fuzzy Search/Filter 2 columns including date

[High77]

Hi,

I hope you are well.

I have 3 spreadsheets, which I have simulated on the belowd L2BB sheet, so it's all in one place. Each box of data is on separate document.

I need to Fuzzy Compare the Activity Sheet to the Allocated Sheet and report which names are missing for each date. Fuzzy compare; as individuals may put Mr A, John A or A as a name. People will also appear in both spreadsheets multiple time, hence the need to match name and date.

I've used the Unique function before, so thought it would be wise to have dates as columns rather than Rows, as the result will be a list of names.

What formula do I need? I'm thinking of a hybrid of =FILTER(B3:B23, ISNA(VLOOKUP(B3:B23, E3:E11, 1, FALSE))) with something to include filtering/v or x lookup by date.

Can you help me include also searching by date as well as Fuzzy search.

Thanks,

High77

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	Allocated Sheet			Activity Sheet			Missing
2	Date	Name		Date	Name		Date	01/01/2022	02/01/2022	03/01/2022
3	01/01/2022	A		01/01/2022	A			B	I	S
4	01/01/2022	B		01/01/2022	C			D	J	T
5	01/01/2022	C		01/01/2022	E			E	K
6	01/01/2022	D		02/01/2022	F				L
7	01/01/2022	E		02/01/2022	G				M
8	02/01/2022	F		02/01/2022	H				N
9	02/01/2022	G		03/01/2022	Q
10	02/01/2022	H		03/01/2022	R
11	02/01/2022	I		03/01/2022	A
12	02/01/2022	J
13	02/01/2022	K
14	02/01/2022	L
15	02/01/2022	M
16	02/01/2022	N
17	02/01/2022	O
18	03/01/2022	P
19	03/01/2022	Q
20	03/01/2022	R
21	03/01/2022	S
22	03/01/2022	T
23	03/01/2022	A
24
Sheet1