Still having touble defining a file path in a formula that reads from a cell in another sheet.

=VLOOKUP(A23,Data!$B$6,Data!$B$13,FALSE)

Data is the sheet name

B6 contains the file path to another workbook and the range $1:$65536 (this doesn't work)

B13 contains the column number (this works fine)


Can anyone help?