Hi all,
I want to vlookup from an closed workbook. i have the below code which pulls up the particular column data from an closed book.
When i apply the formula(=VLOOKUP(B18,'C:\My Documents\Temp\[Demo.xls]Sheet1'!$A$1:$B$10,2,FALSE). the file size gets heavy. Is there an better way around...