Vlookup with Match Reference

Please have a look at the workbook attached.

To explain:

1. Data is obtained by Pivot table from a large dataset
2. For some weeks a survey is not run on 'Zoom' and as default, Pivot would ignore that.
3. What I want to do is have a match on the Vlookup as to when something is not there, it doesn't use the column reference and shows me what is in the column that specific week (Might be Teams, not Zoom)

4. I tried using the formula and I cannot get it to work, please let me know how to fix it.