Using MATCH and CONCATENATE function in VBA

Hello friends,

I need your expertise to solve something.
Attached is a workbook which I'm using to compare
two tables to find out the missing "LSo"users from the previous month.
The VBA code generates the report in a new sheet.

So, I actually need your help on two things;
1. There is a cell called Task Abb, which is a combination of 'J1 and K1 (used CONCATENATE function)
I would like to have the Task Abb to match with the right Task ID(From the Task ID sheet) and show it in the same
'Report' sheet in a new cell next to Task Abb.

eg: TaskAbb TaskID
PDSF_TL 31057215


2. Is there any way that I can use CONCATENATE function in VBA to combine
J1 with K1 ?
I tried, but not working. (YouTube help)


Thanks in advance,
-Jhonny