Re: Very Slow

Tech-Archive recommends: Fix windows errors by optimizing your registry



Check your other post.

Yousoft wrote:

I linked one big file by using Vlookup function but when I trying to open
this file it is taking long time to open, so I need VBA macro to opening this
file fast.
Please any one can help.
Thanks

--

Dave Peterson
.



Relevant Pages

  • Re: vlookup using different workbooks
    ... "Dave Peterson" wrote: ... string that points at the folder, file, sheet, location. ... another workbook. ... is there a way to use a wildcard in a file name in the VLOOKUP function? ...
    (microsoft.public.excel.misc)
  • Re: Using VLOOKUP to draw data from two columns
    ... excel will wrap curly brackets around your formula. ... Dave Peterson wrote: ... >> I am trying to create a VLOOKUP function for two values that are returned ...
    (microsoft.public.excel.misc)
  • Re: =IF(ISERROR(SEARCH("insurance",A125,1)),"","*")
    ... "Dave Peterson" wrote: ... I have a column with photo captions. ... Then in the worksheet you desire the output use the vlookup function: ... Obviously if the list is small then OR will do the trick otherwise I ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Lookup function
    ... vlookup function on my own, but was not getting the "0" ... portion correct. ... >> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: need vlookup function to return the row number
    ... skiing wrote: ... the vlookup function to determine if an item is in that list using ... I would like to know if I can have this function return the cell ... Dave Peterson ...
    (microsoft.public.excel)