Using a hyperlink as table in vlookup


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:

=VLOOKUP(D$1;’Table 1′!A:AS;14;FALSE) 

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!

By: Ei

Leave a Reply

Your email address will not be published. Required fields are marked *