Need help on the following scenario.
I am trying to use the below formula but I cant make it work.
=VLOOKUP(A2,INDIRECT("'C:\Source\["&C2&".xlsx]Sheet1"&"'!"&"$A:$D"),4,0)
I have a masterfile that looks like this.
<tbody>
Task ID
Team
Ops
Status
123
A
Michael
Completed1
456
C
Jude...