Thread: File name from cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default File name from cell
Try

=VLOOKUP(C$2,INDIRECT("'[" & A3 & ".xls]Login'!$M$1:$N$31"),2,FALSE)

If this post helps click Yes
---------------
Jacob Skaria


"Kash" wrote:

=VLOOKUP(C$2,[Malcolm.xls]Login!$M$1:$N$31,2,FALSE)

in the above formula, how to make the file pick from cell? Something like
&A3&".xls"?
Reply With QuoteReply With Quote