Unable to perform Vlookup

@HeartCatcher - please send me input data and expected output. i will create workflow for you.


Input file1 Trial_balance will get after running the macro
Trail_Balance.xlsx (22.6 KB)
Input file2.MasterFile
Spice Money Payments_SEP333’21.xlsx (152.3 KB)
Consider Column “A” in trail balance and Column “Q” in Spice Money Payments both are unique values
After matching the matched data should written in Column “R” in Spice Money Payments.
Expected Op

Workflow file:

With Join.xaml (13.9 KB)

output file:

Abc.xlsx (14.4 KB)

Thanks & Regards