Power Query to find name matches between two spreadsheets

[MrSamExcel]

I have two files: bios v1.2.xlsx and departures v3.4.xlsx. Can Power Query compare the most recent versions of both files saved to the same folder and produce a list of names common to both? The exact match for comparison is:
bios v1.2 -> ‘current’ tab -> “NameFirst”&” “&”NameLast” = departures v3.4 -> ‘remove’ tab -> ”First Name”&” “&“Last Name”
[note: I can do without the blank space between names if much cleaner]

The result would be a list of each entire row from bios v1.2 that contains a match, or just a list of matching [first last] names works too.
I cannot modify the files in any way; ideal solution would not require a user to open either source file.

bios 1.2.xlsx
	A	B	C	D	E	F
1	Code	Date	Ad	NameFirst	NameMid	NameLast
2	ABC-1234-Y99Z	3/18/2015	ABC	Aaron	A	Aaronson
3	ABC-1234-Y200Z	1/1/2000	ABD	ARTHUR	B	ABLABAB
4	ABC-1234-Y200Z	1/1/2005	ABEF	Snowball		Two
5	ABC-1234-Y99Z	1/1/2010	ACDC	Sideshow		Bob
current

departures v3.4.xlsx
	A	B	C	D	E	F
1	Departures List
2	ID	Type	Last Name	First Name	Middle Name	Date
3	1234	Full Time	Aaronson	Aaron		1/1/2022
4	5678	Full Time	Holly	Buddy		2/2/2023
5	10122	Full Time	Bob	Sideshow	T	3/1/2024
6	14566	Full Time	Valens	Richie		1/1/2022
7	19010	Full Time	Bopper	Big		2/2/2023
8	23454	Full Time	Bananas	Mrs		3/1/2024
9	27898	Full Time	Goodwyfe	Prudence	B	1/1/2022
remove

Power Query - Example of Results .xlsx
	A	B	C	D	E	F
1	ABC-1234-Y99Z	3/15/2024	ABC	Aaron	A	Aaronson
2	ABC-1234-Y1100Z	1/1/2023	ACDC	Sideshow	B	Bob
PQ result

 

[sri8462007]

I am writing an if statement formula but getting an below error. what is the issue with this formula in power query?

 

[MrSamExcel]

I am writing an if statement formula but getting an below error. what is the issue with this formula in power query?

Was this intended to be a new thread? Does not appear related to my question.