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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#VALUE! instead of Boolean value 1
Need Help with VLOOKUP 4
Re-calculation 1
Variable Types 4
VLOOKUP 2
Shell "mkdir" 2
Copying files 2
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ? 3

Top