Indirect vlookup problem

R

Romanian37

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
 
I

ivan.raiminius

Hi Will,

indirect returns the reference only if referenced workbook is open.

See help on indirect function for more details.

Regards,

Ivan
 
Top