VLOOKUP and Pivot Tables in Excel

Discussion in 'Community Discussion' started by Frisco, Feb 1, 2007.

Most Liked Posts
  1. Frisco, Feb 1, 2007

    Frisco macrumors 68020

    Joined:
    Sep 24, 2002
    Location:
    Utopia
    #1
    Does anyone know the best way or any resources where I can learn VLOOKUP and Pivot Tables in Excel? I tried Excel help, but it looks way over my head.

    Thanks! I appreciate any suggestions.
     
    share
    + Quote Reply
  2. Kwyjibo, Feb 1, 2007

    Kwyjibo macrumors 68040

    Kwyjibo

    Joined:
    Nov 5, 2002
    #2
    I can't help you with pivot tables but I use vlookup nearly every time I open up the program. Usually I just google the function I need help with and read through an example ...
     
    share
    + Quote Reply
  3. Queso, Feb 1, 2007

    Queso macrumors G4

    Joined:
    Mar 4, 2006
    #3
    I use VLOOKUP quite a lot, but it's far from perfect and I suspect if I looked into it there is a better way. The problem is that if there is no exact match in the reference table, VLOOKUP will return the results for the entry directly below. So the returned results aren't necessarily accurate.

    It's basically a hangover from the Lotus 123 days anyway. Avoid if possible.
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page