VLOOKUP reference

R

Robin Clay

Greetings !


I have this in a Cell :

=VLOOKUP(AL14,[LELTACS.xls]Ali2!$B$28:$B$77,1)

But I want to replace the "77" with the value in Cell BD2
of the current sheet.


Help !


RClay AT haswell DOT com
 
F

Frank Kabel

Hi Robin
try
=VLOOKUP(AL14,INDIRECT("'[LELTACS.xls]Ali2'!$B$28:$B$" & BD2),1)
note: works only if leltacs.xls is open!

Frank
 
Top