I trying to construct a vlookup that gets values from another worksheet in the same workbook. The problem is I will have a different worksheet for every row and I would like to loop through all the worksheets without manually changing the names of the worksheets. My code now is:
The ‘Table 1’!A:AS is the problem. Preferably I would like it to be referencing to a cell which is a hyperlink to the right worksheet but it dosen’t seem to work. I have also tried to use the INDIRECT formula, but only get #REFERENCE? as a result.
Does anyone know how to solve this? Thanks!