Attempting to use Merge for a VLookup in Power Query

[Anonymous]

Very new to Power Query.  I want to perform a Vlookup from another workbook.

I saw an old post with a YouTube Link about Merging Queries.  But, I can't seem to get it to work.

I have 2 Queries that will be Appended:

I tried to Merge the "Append1" with the "VLookup_Combined", but no matches were found.  I know this is incorrect, because I can do a manual VLookup (outside of Power Query), and it works.

What should I be changing?

Can I do this on an Append Table?  Or do I need to perform the Merge on each query, before I Append them?

Here are all the files I'm using:

OneDrive_PowerQuery 

Thanks!

[camargos88]

@Anonymous ,

UPPER -> transform all the text to UPPER CASE

LOWER -> transform all the text to LOWER CASE

https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

[camargos88 · Accepted solution]

@Anonymous ,

Have you tried cleaning both columns with trim/upper|lower function ? 

Power Query is case sensitive and blank spaces in the beginning/end matters for merge.

[Anonymous]

@camargos88 

Aha - That did it!  Thank you, had no idea there was a trim option!

For my learning purposes, what is the upper/lower function please?