Power Query: Which technique will get me the same results as XLOOKUP?

[jnix612]

The final output report will merge 4 tables.

The issue: which technique to use in PQ that will give me the same results as XLOOKUP

1. tblLMS (completed learning)
2. tblCourse (this is the lookup table)

In order to create a pivot table:
I used the unique formula to create a list of original course titles/IDs (this was a hodgepodge of course titles/IDs and none of it followed best practices)
I then matched the LMS course name/ID to the correct course titles/IDs

I need PQ to give me the same results as xlookup. Look at course title and find the matching correct course title display the correct course title, same for the course ID.

Thanks in advance for your time and advise.