VLOOKUP reference

  • Thread starter Thread starter Robin Clay
  • Start date Start date
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
 
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
Re-calculation 1
Need Help with VLOOKUP 4
Variable Types 4
Motherboard help. 3
Shell "mkdir" 2
Excel 2002 Why VLOOKUP(Extract,B$4:C$8,2,FALSE) ? 3
Copying files 2

Back
Top