Results 1 to 10 of 18

Thread: Vlookup

Hybrid 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

  2. #2
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,643
    Articles
    0
    Excel Version
    2010 on Xubuntu
    External links being potentially unsafe and not available to all our members, please post your sheet on the forum ( no pics please - Thx)
    Thank you Ken for this secure forum.

  3. #3
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    52
    Articles
    0
    Excel Version
    2019
    Here is a spreadsheet which teaches you how to do index/match.

    There is an error on the spreadsheet It should say Below are the steps to get to the formula in F2 above, not I2.
    Attached Files Attached Files
    Last edited by Heyjoe; 2019-04-11 at 03:01 PM. Reason: Error in spreadsheet.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,184
    Articles
    0
    Excel Version
    Office 365 Subscription
    Why not simply correct the spreadsheet before uploading it?
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Acolyte Heyjoe's Avatar
    Join Date
    Jan 2019
    Location
    USA
    Posts
    52
    Articles
    0
    Excel Version
    2019
    I found the error after I uploaded it.

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,184
    Articles
    0
    Excel Version
    Office 365 Subscription
    So have you replaced the uploaded spreadsheet with the corrected version? If not, please do so. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

  7. #7
    Acolyte Jlamarre's Avatar
    Join Date
    Nov 2018
    Posts
    22
    Articles
    0
    Excel Version
    2016
    Hello all sorry for not responding sooner. Had a crazy day.

    Tried it at work and had no success. I had to stop and work. I will try later.

    Thanks for your time.

    Sent from my SM-G955W using Tapatalk

  8. #8
    Acolyte maninweb's Avatar
    Join Date
    Mar 2011
    Location
    Germany
    Posts
    88
    Articles
    0
    Excel Version
    2010, 2016, 2016 Insider
    Hi,

    I found this thread from my Analysis Tool of my Excel-Translator Website. And I would like to take the opportunity to
    thank AliGW for linking to my tool here and on other forums too. Thanks!

    I have a note: the online formula translator can not translate table specifiers yet. This is something planned for the next
    version - I hope, I will be ready this summer. While Excel functions have been translated to many languages, but not
    to all available 91 languages, the table specifiers are! For example, #All is #Tout in French, #Alle in German, #Tutti
    in Italian, #모두 in Korean, #すべて in Japanese, #Konke in Zulu or #ყველა in Georgian and many more. So, this
    needs some more complex changes to my tool.

    Best,
    Mourad
    Last edited by maninweb; 2019-04-13 at 08:57 AM.

  9. #9
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,184
    Articles
    0
    Excel Version
    Office 365 Subscription
    Thanks for the note. Let us know when the new version is available.
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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