Results 1 to 10 of 18

Thread: Vlookup

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte Jlamarre's Avatar
    Join Date
    Nov 2018
    Posts
    22
    Articles
    0
    Excel Version
    2016

    Vlookup

    Hello, this might be related to a problem in this thread.

    I read somewhere that a vlookup might be slower then a index/match formula. But for the life of me I can't get it working. (even my vlookup on the information I read looking for does not work). No idea why.

    Now my file is sheet1 (a table) that will gather information from other sheets in the same folder. The other sheets are getting theire information from an Sql query. So in each of the other sheets I have a copy of the sql table. (is this the best setup?)

    Should I use index/match instead of vlookup?

    My file hangs often. That's what I'm trying to resolve.

    Thanks
    Jl


    Sent from my SM-G955W using Tapatalk
    Last edited by Pecoflyer; 2019-04-11 at 07:54 AM. Reason: Removed external link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •