software

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: www.excelforum.com/member.php...foamp;userid=9759
View this thread: www.excelforum.com/showthread...hreadid=534163Hi Will,

indirect returns the reference only if referenced workbook is open.

See help on indirect function for more details.

Regards,

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Romanian37quot; gt; wrote
in message ...
gt;
gt; Why does
gt; =VLOOKUP($T7,'G:\Irevna\Oils\Models\WIP\[BP WIP.xls]KADS Upload
gt; Template 2'!$H$11:$S$100,Z$2,0) work but
gt; =VLOOKUP($T7,INDIRECT(GD7),Z$2,0) not work
gt;
gt; (where GD7 = G:\Irevna\Oils\Models\WIP\[BP WIP.xls]KADS Upload Template
gt; 2'!$H$11:$S$100)
gt;
gt; Thanks for any help...
gt;
gt; Will
gt;
gt;
gt; --
gt; Romanian37
gt; ------------------------------------------------------------------------
gt; Romanian37's Profile:
www.excelforum.com/member.php...foamp;userid=9759
gt; View this thread: www.excelforum.com/showthread...hreadid=534163
gt;

thanks for the help (and quick response)--
Romanian37
------------------------------------------------------------------------
Romanian37's Profile: www.excelforum.com/member.php...foamp;userid=9759
View this thread: www.excelforum.com/showthread...hreadid=534163