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