Why does
=VLOOKUP($T7,'G:\Irevna\Oils\Models\WIP\[BP WIP.xls]KADS Upload
Template 2'!$H$11:$S$100,Z$2,0) work but
=VLOOKUP($T7,INDIRECT(GD7),Z$2,0) not work

(where GD7 = G:\Irevna\Oils\Models\WIP\[BP WIP.xls]KADS Upload Template
2'!$H$11:$S$100)

Thanks for any help...

Will


--
Romanian37
------------------------------------------------------------------------
Romanian37's Profile: http://www.excelforum.com/member.php...fo&userid=9759
View this thread: http://www.excelforum.com/showthread...hreadid=534163

Hi Will,

indirect returns the reference only if referenced workbook is open.

See help on indirect function for more details.

Regards,

Ivan

Because INDIRECT does not work on closed files. See
http://makeashorterlink.com/?F2993260A for an alternative solution.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Romanian37" wrote
in message ...

Why does
=VLOOKUP($T7,'G:\Irevna\Oils\Models\WIP\[BP WIP.xls]KADS Upload
Template 2'!$H$11:$S$100,Z$2,0) work but
=VLOOKUP($T7,INDIRECT(GD7),Z$2,0) not work

(where GD7 = G:\Irevna\Oils\Models\WIP\[BP WIP.xls]KADS Upload Template
2'!$H$11:$S$100)

Thanks for any help...

Will


--
Romanian37
------------------------------------------------------------------------
Romanian37's Profile:
http://www.excelforum.com/member.php...fo&userid=9759
View this thread: http://www.excelforum.com/showthread...hreadid=534163

thanks for the help (and quick response)


--
Romanian37
------------------------------------------------------------------------
Romanian37's Profile: http://www.excelforum.com/member.php...fo&userid=9759
View this thread: http://www.excelforum.com/showthread...hreadid=534163